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.
N9950AHilbert Lee D · Hampton, NJN9950NRegistration Pending · Petersburg, AKRegistration pending, pending cancellationN9950XHedlund Mark · Kasilof, AKN99517Civil Air Patrol Inc · Maxwell Afb, ALN9951EBlue Skylane LLC · Sunriver, ORN9951HFormula 182 LLC · Phoenix, AZN9951NAckerman Dennis W · Anchorage, AKN9951V9951v Aircraft Leasing LLC · Spanish Fork, UTN9951XBrown Rosalee Jo · Minnetrista, MNN99527Delta State University · Cleveland, MSN9952MAlaska Aircraft Leasing LLC · Silverdale, WAN9952RBlanchard Ken E · Lumberton, MSN9952ZMcdougall Enterprises LLC · Tualatin, ORN99532Civil Air Patrol Inc · Maxwell Afb, ALN9953CEjj Group Inc · New York, NYN9953ESutton Gregg S · Orono, MNN9953HRegistered aircraftN9953MAlaska Aircraft Leasing LLC · Silverdale, WAN9954ANolen Donald F · Plano, TXN9954BWest James R · Xenia, OHN9954EChase Ronald L · Payson, AZN9954HApplied Dimension LLC · Hinsdale, NYN9954NWhitmer Lyle E · Fairbanks, AKN9954TWoodford Douglas P · Colbert, WAN99553Jka LLC · Notasulga, ALN9955ANelson Harry J · West Bend, WIN9955CBrenna Matt R · Austin, TXN9955ESanchez Angel David · Houston, TXN9955JMehling Robert C · Hardin, MTN9955TWheeler Aaron T · Columbia, TNN9955XMurphy Niccolai A · Poway, CAN9956EBankuti Steve A · Littlerock, WAN9956HOldtown Aviation LLC · Priest River, IDN9956MRyan Air Inc · Anchorage, AKN9956VFetch N Wag LLC · Sarasota, FLN9957ADunn Ward A · Columbia, SCN9957BToby Aviation LLC · Manassas, VAN9957EReisman Richard H · Montrose, CON9957MArctic Aviation Leasing LLC · Anchorage, AKN9957NGasper Air Spray Inc · Crookston, MNFirst renewal noticeN9957RScg Leasing LLC · Owensboro, KYN9957TDaniels Luke D · Palmer, AKN9957XHutchison Robert T · Big Lake, AKN99583Motz Gary A · Bemidji, MNN99589Kingsky Flight Academy LLC · Lakeland, FLN9958AChase Kevin J · Anchorage, AKFirst renewal noticeN9958BSouthern Aircraft Leasing LLC · Montgomery, ALN9958EAirtauk LLC · Montauk, NYN9958HCity Of Albuquerque · Albuquerque, NMN9958NShimpa Michael A · Maple Grove, MN
Back to AD 87-20-03 R2