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.
N906RSSouthern Aircraft Consultancy Inc Trustee · Casper, WYN906WAPea-Wayman Flight LLC · Daytona Beach, FLN9070AKerr Colleen A · Waukesha, WIN9070MBeyer Family Aviation LLC · Hamilton, MTN9070XWeisenberger Michael J · Norwalk, OHN9072M3580 Shelby Flyers LLC · Shelby, NCN9073TEds Auto Inc · Union City, MIN9073XHartung Eric C · Howard, SDN9074GRush Wayne A · Troy, KSN9074TRollinson Mark H · South CanterburyN9074XDistel Richard G · Loveland, CON9075AKingdom Air Corps · Sutton, AKN9075MBumback William R · Seattle, WAN90763Apex Aircraft Leasing LLC · Anchorage, AKN9076AList Oliver · Wasilla, AKN9076CEvv Pilots Club Inc · Evansville, INN9076MFowler Kenneth R · Locust Fork, ALN9077ADay Jeffrey R · Haslet, TXN9077C389 Fifth Street LLC · Placida, FLN9077TMegilligan Scott M · Johnstown, CON9077XTmax Aviation LLC · Newcastle, WYN9078MD R I Enterprises Ltd · Decatur, TXN9079AMandere Mark Edward · Spokane Valley, WAN9079GHenriksen Gary L · Sequim, WAN9079HJoey Os LLC · Darlington, PAN9079XWessel Eric B · Peabody, KSN907AKErickson Michael J Jr · Juneau, AKN907ATAirglas Inc · Achorage, AKN907AZN907az LLC · Miami, FLN907CERoss Peter W Trustee · Lufkin, TXN907CSSteggerda Scott · Anchorage, AKN907EEEriksen Eric Edward · South Fork, CON907FMiller Jonathan L · Anchorage, AKN907GGGleim Education Inc · Gainesville, FLN907JMWright Flight Inc · Tucson, AZN907KSKingsky Flight Academy LLC · Lakeland, FLN907LMDe Gavere Lambert M · Anchorage, AKN907PBMorris Engineering Group Inc · Auke Bay, AKN907RKKulin Robb M · Anchorage, AKN907TTHangar Ak LLC · Sterling, AKN907WAPea-Wayman Flight LLC · Daytona Beach, FLN9081GIfr Investments LLC · Covington, LAN9081HRich Lucas Aircraft Sales LLC · Lincoln Park, NJN9081MValiair Lc Trustee · Casper, WYN9081XKardack Michael R · Lopez Island, WAN9082TFly By Knights Aero Club Inc · Bay City, MIN9083AStorch Shaidon P · Deer Park, WAN9083HNewton Aero LLC · Hurdland, MON9083RStuder Alfred C · Shelby, MIN9083XAhl Of Montana LLC · Lolo, MT
Back to AD 87-20-03 R2