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.
N9077JStreuer Troy · Smithville, TXN9077KPacific Coast Aero Inc · Torrance, CAN9077LVeilleux Payton L · Pittsfield, VTN9077PFarris James E · Brentwood, TNFirst renewal noticeN9077WSmith Dwayne · Manassas, VAN90783Rudd Wayne G · Basalt, CON9078DChandelle Ltd · Brighton, CON9078JConner W Larry · Los Lunas, NMN9078VRich Lucas Aircraft Sales LLC · Lincoln Park, NJN9078WWood Trey A · Colorado City, TXN9078YParker Ron L · Melissa, TXN9079DThomas William C · Blanchardville, WIN9079JTestruth Gary R · Coarsegold, CAN9079NFlorida State College At Jacksonville · Jacksonville, FLN9079PTyrrel David E · Harlan, IAN9079TLuther David J Trustee · Saint Maries, IDN9079VAbramson Derek J · Lancaster, CAN907AGAntique Aircraft And Automobile LLC · Van Alstyne, TXN907APWheeler David A · Kennewick, WAN907AXNeuman Cort J · Palmer, AKN907AZN907az LLC · Miami, FLN907BPBryant Stephen C · Anchorage, AKN907BTKramer Michael · Talkeetna, AKN907CCOconnor Lloyd Thomas · Dillingham, AKN907CPCivil Air Patrol Inc · Maxwell Afb, ALN907CUDenny Roger A Jr · Eagle River, AKN907DTLanni Douglas W · Fairbanks, AKN907FVGuthrie Richard A · Anchorage, AKN907GDAir Charter Inc DBA · Culebra, PRN907GJKincaid Levi L · Palmer, AKN907GPGittlein Paul A · Wasilla, AKN907HHarding Jason I · Wasilla, AKN907HGDenali North Side Adventures LLC · Wasilla, AKN907HRMerrill Andrew T · Bethel, AKN907JConaway Jeffrey Scott · Anchorage, AKN907JAAnderson James C · Wasilla, AKFirst renewal noticeN907JSStevenson William E · Sutton, AKN907KSKingsky Flight Academy LLC · Lakeland, FLN907KYYoung Richard H · Eagle River, AKN907LEAll Her Fault LLC · Fairbanks, AKN907LJAgl Aero LLC · Mckinney, TXN907LLAerial Ag Services LLC · Hillsboro, TXN907LPMicro Publishing Press Inc · Truckee, CAN907MWaitman Bradley J · Wasilla, AKN907PKBachus James Ross · Stephenville, TXN907PMMinelga Paul · Soldotna, AKN907PSBrock W Walker · Charleston, SCN907RDLynch James P · Santa Barbara, CAN907RFFinch Robert C · Anchorage, AKN907RUBlahut Michael · Anchorage, AK
Back to AD 87-10-06 R1