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.
N74KLMccoy Mark C · Ocoee, FLN74KNNewby Kent P · Centennial, CON74LGGriffin Larry D · Lubbock, TXN74LPMendota Flyers LLC · Middleton, WIN74LTDevor Aviation Support Services LLC · Chambersburg, PAN74MHRichmond Wheeler LLC · Marshfield, WIN74MRRubbert Jan Dale · Upham, NDN74NANelson Kenneth · Caledonia, WIN74PAApplegate David L · Oakland, IAN74PESkycrafters Incorporated · Johnson City, TNN74PKRegistered aircraftN74PPBunnell Randy D · Blakesburg, IAN74RCKellogg Milton R · Erie, KSN74RGRio Grande Helicopters Inc · Laredo, TXN74RVMazankowski Scott M · San Diego, CAN74SBNorman Bradley T · Rosamond, CAFirst renewal noticeN74SRGodwin David P · Bryan, TXN74SSPelletier Kevin C · Williamsport, MDN74STRybczynski Douglas R · Chandler, AZN74SXRegistered aircraftN74THDe Gracia Jack P · Orlando, FLN74TLLombardi Thomas C · Camp Verde, AZN74TXPhillips John R · Tucson, AZN74VEDenton David T · Williamson, GAN74WBJefferies Eric · Weatherford, TXN74WFWeber Stephen J · Hastings, MNN74WKKennedy Wade J · Catawba, NCN74WRPrecision Millwright & Machine Inc · Villa Park, ILN74WWWhitewind Co · Windsor Locks, CTN74WYMackey Livestock LLC · Alva, OKN74XRundell Lanny · Winnsboro, LAN74YCButzer Brian K · Boca Raton, FLN75005Spiesman William J · Austin, TXN75008Rector Allen · Marshall, VAN7500DRiggin Flight Service Inc · Madison, SDN7500FGrindley John E · Hopewell Junction, NYN7500HRobinson Eric C · Palmer, AKN7500JNour George E · Eatonton, GAN7500PBas Part Sales LLC · Greeley, CON7500RSzymanski Tadeusz C · Fort Myers, FLN7500WGajewski Richard G · Naples, FLN7501FStafford Tech Inc · Rehoboth, MAN7501JSholl Douglas Alan Jr · Williams, AZN7501WTide Pools LLC · Tucson, AZN75021Miller Mariemma L · Martinsburg, PAN7502DFlight Lead LLC · Casper, WYN7502FBarrie Lorna D · Tonawanda, NYN7502HCountry Air Service Inc · Hecla, SDN7502JIrvin H Hugh · Salina, KSN7502RStapleton James W Jr · Nebo, NC
Back to AD 81-18-04 R2