AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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.
N74MHRichmond Wheeler LLC · Marshfield, WIN74MRRubbert Jan Dale · Upham, NDN74MWAvions Frousses LLC · Evanston, WYN74NANelson Kenneth · Caledonia, WIN74PAApplegate David L · Oakland, IAN74PESkycrafters Incorporated · Johnson City, TNN74PKRegistered aircraftN74PPBunnell Randy D · Blakesburg, IAN74RCKellogg Milton R · Erie, KSN74RVMazankowski Scott M · San Diego, CAN74SBNorman Bradley T · Rosamond, CAFirst renewal noticeN74SRGodwin David P · Bryan, TXN74SSPelletier Kevin C · Williamsport, MDN74STRybczynski Douglas R · Chandler, AZN74THDe 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, ILN74XRundell Lanny · Winnsboro, LAN74YCButzer Brian K · Boca Raton, FLN75001Bowe Walter C Trustee · Sonoma, CAN75005Spiesman William J · Austin, TXN7500DRiggin Flight Service Inc · Madison, SDN7500FGrindley John E · Hopewell Junction, NYN7500HRobinson Eric C · Palmer, AKN7500JNour George E · Eatonton, GAN7500RSzymanski 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, NCN7502VBluewater Bay LLC · Ardmore, OKN75039Mulligan Peter · Richardson, TXN7503FPatton David · Elmendorf, TXN7503RQuinn George B · Ponce, PRN7503VChuga Gregory M II · Hayes, VAFirst renewal noticeN7503WAscend Aviation LLC · Bountiful, UTN7503YCunneen Sean M · Vista, CAN75046Esson Michael · Durand, MIN75047Dunlop Vance Trustee · Keizer, OR
Back to AD 90-04-06 R1