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.
N97159Quetzal Aviation Corp · Washington, DCN9715AGarry L Lewis · Livingston, LAN9715GMonfore Mark A · Wasilla, AKN97160Foster Mark C Trustee · Carson City, NVN97163Civil Air Patrol Inc · Maxwell Afb, ALN9716BSelkirk Associates Inc · Wilmington, DEN9716XLowe Joshua T · Mount Baldy, CAN97170Connor Catherine E · Morgantown, WVN97172C P Aviation · Santa Paula, CAN97178Meador Rita R · Eldorado, TXN9717BCeruto Jorge · Auburndale, FLN9717GBurley Mark A · North Pole, AKN9717HBullock Linda A · Shawnee, KSFirst renewal noticeN9717QRosenberger Gregg J · Keller, TXN9717VTco Inc · Stanley, NDN9717XEichner David K · Portland, ORN9718GCain Curtis S · Reno, NVN9718HDyer Stacey T · Jensen Beach, FLN9718XLooney Jeffrey J · New Boston, TXN97190Hickman Donald E II Trustee · Medford, ORN97192Atlantis Construction Inc · Friday Harbor, WAN97196N2893e LLC · Reno, NVN97199Perry Martin Dale · Denton, TXN9719VCumbie Curtis F · Fayetteville, ARN971AAHobgood David · Bartow, FLN971BBColon Hector L · Gainesville, GAN971FMFreeway Airport Inc · Mitchellville, MDN971RWSutherland James P · Wausau, WIN97200Aragon Cecilia · Sequim, WAN9720GZarones Erik R · Paris, TXN9720MIliamna Air Taxi Inc · Iliamna, AKN9720NNash Clay S · Irving, TXN9720RPca Tail One LLC · Wilmington, DEN9720VBoobas John P · Nicholson, GAN9720XHogue Richard L · Dos Palos, CAN97211G & G 24 LLC · Clancy, MTN97218Mcgraw Thomas M II · Prescott, AZN9721GFahrenbruck George · Anchorage, AKN9721HFoster Gary P · Anchorage, AKN9721ZRwr Inc · Wasilla, AKN97220Summit Crest Capital LLC · Palos Heights, ILN97221Smith Brian A · Big Pine Key, FLN9722HQuad Cities Aero LLC · Bettendorf, IAN9722TFoust Richard W · Minneapolis, KSN9722VTck Services LLC · Millington, MIN9722XEddy David A · Gilroy, CAN97231Pacific Rim Aviation LLC · Corvallis, ORN97233Frahm Lon R · Colby, KSN97237Headley Mark E · Akron, OHN97238Sanctuary Wings LLC · Norfolk, VA
Back to AD 87-20-03 R2