AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
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:79-10-14-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1') 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.
N989WDTextron Aviation Employees Flying Club Inc · Wichita, KSN989WUEglin Aero Club · Eglin Afb, FLN98BVUSA Air LLC · Ruskin, FLN98DDReady Aim Flyer LLC · New Castle, DEN98DXInternational Air Services Inc Trustee · Carson City, NVN98EMGreen Tool & Die Co LLC · Honesdale, PAN98FFPeregrine Howard Fund V Owner LLC · New Orleans, LAN98GCGarcia Alexandra · Pompano Beach, FLN98JBFlight1 Hsw LLC · Norwood, CON98MLPlr Services LLC · Stuart, FLN98PBFerry Services Corp · Cresson, TXN98SSSoutheastern Oklahoma State University · Durant, OKN98SWGankas Christopher · Ventura, CAN98TCPositiv8 LLC · Wilmington, DEN98TDLewis John Cory · Modesto, CAN98VFFitzpatrick Patrick D · Titusville, FLN98WHN94ee LLC · West Palm Beach, FLN98WYCheyenne Flying Club LLC · Cheyenne, WYN98ZTSharp Paul A II · Apollo Beach, FLN9900BS & L Aviation LLC · Buhl, IDN9900GSkyline Agrinautics Inc · Osage, IAN9900NRegistered aircraftN9900QBedsole Clinton Allen · Frisco, TXN9900THamlin Timothy B · Garden City, KSN9901BNichols Patrick C · Fairview, NCN9901EBas Part Sales LLC · Greeley, CON9901NTeets David J · Fairbanks, AKN9901VMinske Troy · Princeton, MNN9902EOtto Real Estate Investment Inc · Bakersfield, CAN9902QBowers John E · Owasso, OKN9902VEuroaviation Inc Trustee · KematenN9903GCourtney Brooks Streetwise Inc · Avondale, AZFirst renewal noticeN9903MRegistered aircraftN9903TRiddle John G · Townsend, MTN9903VDwh Flight LLC · Spring, TXN99040Bradley Aircraft Company LLC · Columbus, INN99045Allen Michael R · Graham, NCN99048Bradley Aircraft Co · Columbus, INN9904HWingin It LLC · Marshall, MNN9904QStanford Jay J · Saint Marys, GAN9904VStratus Aviation LLC DBA · Vacaville, CAN9905AHottois Scott A · Whittemore, MIN9905ELf Flying LLC · Wellington, MON9905FNew Horizon Aviation Inc · Warwick, RIN9905HWhitaker Billy Dean Jr · Houston, TXN9905QCentral Air Service · Lewistown, MTN9906GNielson Donald L · Independence, ORN9906LRiseaero LLC · Florence, SCN9906MWhorton Darren · Nashville, TNN9906VStruempler Jed E · Anchorage, AK
Back to AD 79-10-14 R1