AD 87-10-06 R1
Registered aircraft · 72,010
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-10-06-R1')
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-10-06-R1')
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-10-06-R1') 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-10-06-R1') 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.
N8064RN8064r LLC · Kalispell, MTN8064WSled Aviation LLC · Prosper, TXN80657Shelburne Airport Inc · Shelburne, VTN8065CArrow Air LLC · Sioux Center, IAN8065HJehnes Jens W · Cocoa, FLN8065JHerlihy John Joseph · Arroyo Grande, CAN8065NSotelo Kaleb N · Visalia, CAN8065PEyrich Richard Lee · Cave Creek, AZN8065WGard Roger L · Danville, IAN8065YTipton Aero Shares LLC · Fort Meade, MDN80669Buchert Barbara K · Shrewsbury, MAN8066NSouthern Air Services LLC · Myakka City, FLN8066UBayphoto Helicopter LLC · Rehoboth Beach, DEN8066WWilson Jamal Abdul · White Plains, MDN80670Jb Aviation Management Inc · Wonder Lake, ILN80673Mitchell Aviation LLC · Mitchell, SDN80678Aero Maintenance Inc · Vancouver, WAN8067DBurgess Bruce A · Saint Johns, MIN8067JCc Air LLC · Orchard, NEN8067NCsp Avionics LLC · Knoxville, TNN8067PShreve Jerry L · Warrensburg, MON80684Domino Adam P · Saint Petersburg, FLN8068CThunderbird Aircraft Company · Bloomington, MNN8068JGo Vertical Aviation LLC · Russellville, ALN8068WRkd Flier Inc · Nemaha, IAN8068ZBasco John J · Pottstown, PAN80692Registered aircraftN80697Moe-Air LLC · Cincinnati, OHN8069AInfinity Aviation St Cloud LLC · Rice, MNN8069DCasey Michael B · Hemingford, NEN8069NRajski Douglas S · Freeburg, ILN8069PNw Contract Services LLC · Graham, WAN8069SGates Joel L · Salida, CON8069WAdventures In The Sky Aviation LLC · Fresno, CAN806ATFlight School Of Texas LLC · Wilmington, DEN806BBNoyes Jimmy D · Fruitland, IDN806CRAircraft Registration Inc Trustee · KematenN806CWWilling John W · Grove City, OHN806DAPeak Leasing LLC · Anchorage, AKN806EHFisher Air LLC · Cardington, OHN806ERDiamond Aircraft Sales Of Kentucy LLC · Henderson, KYN806FTJohnson Daniel S · Louisville, KYN806GPPractical Educators Association · Amelia, VAN806HAFlywell Aviation LLC · Bowling Green, KYN806NVFlight Operations Inc · Lewes, DEN806PBAircraft Registration Inc Trustee · KematenN806RRIsland Flights Inc · Wilmington, DEN806RVPastorek Jordan M · Frisco, TXN806SPAir Marion Inc · Marion, INN806TDWall Joseph J · Chamberlain, SD
Back to AD 87-10-06 R1