AD 81-18-04 R2
Registered aircraft · 81,733
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N9937DSky High Adventures LLC · Wilmington, DEN9937E7 And 7 LLC · Leon, IAN9937QFosmo Richard E · Eatonville, WAN9937YWoods Justin S · West Glacier, MTN9938DStrub Henry J Jr · Dillingham, AKN9938UBurton Kenneth G · Hebron, INN9938WBerger Alexander W · Richmond, VAN9938YSchneider Bros · Manning, NDN99396Flightline Air Service LLC · Pineville, LAN9939HVawter Russell R Trustee · Nampa, IDN9939LPaquet Michael D · Milton, FLN9939UGlover Joseph · Defuniak Springs, FLN9939WHoward Dwight · Beverly Hills, FLN9939YGehrke Walter L · Willow Lake, SDN993CCSale Reported · Kasota, MNSale reported, pending cancellationN993CMClaypool James W · Hunts Point, WAN993DBBauer Dereck R · Springfield, ORN993DCCoulter Daniel J · Mooresville, NCN993DGGardner David M · Rocklin, CAN993FAKjerstad Rodney R · Phoenix, AZN993FGFlightgest Academy LLC · Morrisville, NCN993GWSol Aviation LLC · Salem, ORN993MCTucker Bill F · Booneville, ARN993PDCertified Aviation LLC · Morristown, NJN993RMPalm Aerobatic Aircraft LLC · Port Saint Lucie, FLN994Henning David L · Port Orange, FLN9940VSoco Aero Leasing LLC · Santa Rosa, CAN9940WStaley Harvey Russell · Brandon, FLN9941DPye Jenny · Roanoke, TXN9941LWelch Steven R · North Aurora, ILN9941UParsons Stephen · Wellington, FLN9942QWarren John Russell · Los Alamos, NMN9942WMccafferty R Joseph · Winfield, MON9942YHardy John R · Wasilla, AKN9943ELerud Peder E · Stockton, CAN9943QGrove Todd M · Lake Stevens, WAN9943URandall Steve · Oakland, CAN9943YDehlin James M · Roscommon, MIN9944CLarsen John E · Adrian, MIN9944DRed Baron LLC · Dickinson, NDN9944LSimpson Robert W · Farmerville, LAN9944QSkywarrior Flight Training Inc · Pensacola, FLN99450Castellucci Jason G · Los Angeles, CAN9945EWilcox John C · Aurora, NEN9945PBonner Richard A · Garrettsville, OHN9945QClassic Air Aviation LLC · Mesa, AZN99465Farzam Hamid · Newington, CTN99467Civil Air Patrol Inc · Maxwell Afb, ALN9946QHorizon Aviation LLC · Sinclair, MEN9946URiffel Betty Grace · Clinton, MO
Back to AD 81-18-04 R2