AD 87-10-06 R1
Registered aircraft · 72,010
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:87-10-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:87-10-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:87-10-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:87-10-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.
N74ERSimplifly LLC · Mesa, AZN74FAMangelsdorf David M · Raton, NMN74FPPettit Myron F · Mesa, AZN74GMMellen George J · Powell, OHFirst renewal noticeN74HPRoberts Joseph F · Bell Buckle, TNN74HYRegistration Pending · Roundup, MTRegistration pendingN74JDMazza Joseph D · Queensbury, NYN74JJWard Ralph G · Parrish, FLN74JPGulf Coast Helicopters Inc · Pearland, TXN74KDDannenberg Kenneth H · Holland, MIN74KKKrauser Kent F · Lake Mary, FLN74KLMccoy Mark C · Ocoee, FLN74KNNewby Kent P · Centennial, CON74LGGriffin Larry D · Lubbock, TXN74LPMendota Flyers LLC · Middleton, WIN74LRRemy Lange · East Greenville, PAN74LSAerodyne Industires Corp · Elburn, ILN74LTDevor Aviation Support Services LLC · Chambersburg, PAN74MHRichmond Wheeler LLC · Marshfield, WIN74MJFord Richard M · Cartersville, GAN74MRRubbert Jan Dale · Upham, NDN74NANelson Kenneth · Caledonia, WIN74PAApplegate David L · Oakland, IAN74PESkycrafters Incorporated · Johnson City, TNN74PKRegistered aircraftN74PLAncient Pelican Aviation LLC · Vero Beach, FLN74PPBunnell Randy D · Blakesburg, IAN74RGRio Grande Helicopters Inc · Laredo, TXN74SRGodwin David P · Bryan, TXN74STRybczynski 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, TXN74WDNevada Viking Partners LLC · Stateline, NVN74WFWeber Stephen J · Hastings, MNN74WKKennedy Wade J · Catawba, NCN74WRPrecision Millwright & Machine Inc · Villa Park, ILN74WWWhitewind Co · Windsor Locks, CTN74XRundell Lanny · Winnsboro, LAN74YCButzer Brian K · Boca Raton, FLN75005Spiesman William J · Austin, TXN75008Rector Allen · Marshall, VAN7500DRiggin Flight Service Inc · Madison, SDN7500FGrindley John E · Hopewell Junction, NYN7500JNour George E · Eatonton, GAN7500PBas Part Sales LLC · Greeley, CON7500RSzymanski Tadeusz C · Fort Myers, FL
Back to AD 87-10-06 R1