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.
N9732AMoremen Joshua · Sagle, IDN9732GFulcher David B · Glendale, AZN9732HLand & Leave LLC · Helena, MTN9732VSiguaw Robert E · Deming, WAN9733ACloud Dancer Aviation Inc · Deland, FLN9733GZimmitti Andrew · Mclean, VAN9733HStephens Jack J · Kingwood, TXN9733LStock Craig A · Devon, PAN9733VTyler Ronald J · Martville, NYN97345Postupack Peter Jr · New Cumberland, PAN9734AGreen Theodore G II · Burlington, WIN9734BPreston Aviation LLC · Henderson, KYN97358Rick Aviation Inc · Newport News, VAN9735XPascal LLC · Des Moines, WAN97361Sky 4 Me LLC · Greendale, WIN97365Sugg Robert Michael · Covington, GAN9736BWrigley David C · Anchorage, AKN9736GBrakey Richard F · Amarillo, TXN9736HBrentco Aerial Patrol Inc · Canton, OHN9736MRyan Air Inc · Anchorage, AKN9737GZamoruev Alexander Vladimirovich Trustee · Anchorage, AKN9737HXyz Aviation LLC · Rineyville, KYN9737VAero Equities LLC · Ventura, CAN97380Rsf Services LLC · Salem, ORN97385182q LLC · Tyler, TXN97386Ratcliffe & Sons Inc · Madill, OKN9738ADemio Douglas · Westbrook, CTN9738HBallard Bradley J · Youngsville, NCN9738XAdelman Timothy B · Stevensville, MDN97396Sds Aviation Inc · Buford, GAN97398Dbat Flying Club LLC · Reno, NVN9739GBjork Richard J · Brackettville, TXN973JMMarc Inc · Bolton, MSN973KGRichard Mervin J Jr · Washington, DCN973SRRegistration Pending · Kuna, IDRegistration pendingN973WDBaggenstoss William J · Weiser, IDN9740GKestrel Kat LLC · Wilmington, DEN97410Skynuke LLC · Bechtelsville, PAN97413Northwoods Air LLC · Orono, MEN9741AHelzer Michelle A · Canby, ORN9741XHalbert Larry E · Jacksonville, FLN97428Right Wing Aviation LLC · Fort Wayne, INN9742BHarp Aviation LLC · Flemington, NJN9742HSingularity - Intelligence Amplified LLC · Conesus, NYN9742VN9742v LLC · Ord, NEN97433Menyhay William Csaba · Clovis, CAN97435Wipaire Inc · South Saint Paul, MNN97437Carr Jeffrey A · Worthington, KYN9743AYokom James C · Wichita, KSN9743BVinson Paul E DBA · Gainesville, GA
Back to AD 87-20-03 R2