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.
N968RCAmelia Reid Aviation LLC · San Jose, CAN96906Nulisch Justin · Del Rio, TXN9690HConner Mark H · Wauna, WAN9690QRobinson Neil A · Madison, WIN9690VAlbrecht William J Jr · Greenville, NCN96911Luciano Edmund R · Anchorage, AKN96919Mckitrick Brad L · West Jefferson, OHN9691BRegistered aircraftN9691GFox Michael F · Hernando, FLN9691VNewman Philip · Georgetown, TXN9691ZSouth America Mission Inc · Fort Mill, SCN96923Green David C · Milford, IAN96928Jurkowski Raymond · Germantown, NYN96929Ware Joseph B · Angleton, TXN9692BAberdeen Flying Service · Aberdeen, SDN9692THarbaugh Eric M · Russell, KSN9692VShow Low Flight Academy LLC · Show Low, AZN9692YA Viation Inc · Bennettsville, SCN96932Valiair Lc Trustee · Casper, WYN9693HClear Creek Aviation LLC · Buffalo, WYN9693QHughes Ronnie D · Cedar Park, TXN9693VRabideau William J III · Stafford Springs, CTN96943Porta Michael W · Old Bridge, NJN96949Pittman William Greg · Anchorage, AKN9694HFitch William R · Dubuque, IAN9694LCivil Air Patrol Inc · Maxwell Afb, ALN9694QBexbach North America LLC · Reno, NVN9694TGarza Gilberto · Yuma, AZN9694VHaller Patrick C · York, SCN9694XDawson Timothy E · Dahlonega, GAN96952Gospel Ministries International · Collegedale, TNN9695HGoddard Robert J · Haverhill, MAN9695XHam Robert · El Cajon, CAN96968Shaw Stephen A · Sherwood, ORN9696HMirror Image Inc · Belgrade, MTN9696LAny Border LLC · Yankton, SDN9696TJ & F Aviation Adventure LLC · North Fort Myers, FLN96977Couch Christopher · Huntertown, INN9697QCaltagirone Peter J · Lewes, DEN9697VWestern Edge Aviation LLC · Dickinson, NDN96988Wenner Aaron · Tehachapi, CAN9698EPark Rapids Avionics Inc · Park Rapids, MNN9698GCash Jeffery Scott · Gresham, ORN9698HEagle Simulator LLC · Lake Oswego, ORN9698VVermont Flight Academy Inc · South Burlington, VTN96991Johnson Kirk · Klamath Falls, ORN9699GCruikshank Brian S · Portland, ORN9699HDamschroder Rex A · Fremont, OHN9699TBas Part Sales LLC · Greeley, CON9699VPiercy Danille Marie · North Bay Village, FL
Back to AD 87-20-03 R2