AD 87-20-03 R2
Registered aircraft · 54,015
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-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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.
N98BVUSA Air LLC · Ruskin, FLN98DDReady Aim Flyer LLC · New Castle, DEN98DXInternational Air Services Inc Trustee · Carson City, NVN98EMGreen Tool & Die Co LLC · Honesdale, PAN98GCGarcia Alexandra · Pompano Beach, FLN98GPHammack Philip Scott · Canton, MSN98JBFlight1 Hsw LLC · Norwood, CON98PBFerry Services Corp · Cresson, TXN98SSSoutheastern Oklahoma State University · Durant, OKN98SWGankas Christopher · Ventura, CAN98TCPositiv8 LLC · Wilmington, DEN98ZTSharp 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, MON9905HWhitaker Billy Dean Jr · Houston, TXN9905QCentral Air Service · Lewistown, MTN9906GNielson Donald L · Independence, ORN9906LRiseaero LLC · Florence, SCN9906MWhorton Darren · Nashville, TNN9906VStruempler Jed E · Anchorage, AKN9907AHuff Steven D · Lake Havasu City, AZN9907BMalone Parachute Club Inc · Williston, VTN9907CBlue Marlin LLC · Kalispell, MTN9907HMather Aviation LLC · Mather, CAN9907QPlasco Designs Of Arkansas Inc · Texarkana, ARN9908AKelly Larry E · Currie, NCN9908EAndrews Allen P · Longview, TXN9908GHarrison Jon Wittmeyer · Port Saint Lucie, FL
Back to AD 87-20-03 R2