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.
N64383Mission Aviation Training Academy · Arlington, WAN64390Zarpak Shahab Mike · Bethesda, MDN6439PWalter Sean E · Vancouver, WAN643FLGoudy Steven A · Wheatland, WYN643FTFlorida Institute Of Technology · Melbourne, FLN643GAir Leasing Inc · Evanston, ILN643HHagglund Caleb J · Pendleton, ORN643MDLacey Robert E · Yankton, SDN643MTLaurel Fork Aviation LLC · Charlottesville, VAN643PEColiseum Aviation LLC · Little Rock, ARN643RShowerman Michael · Urbana, ILN643SPRegistered aircraftN643TPMcconwell Edward A Sr · Mission, KSN644Wine Street Aviation LLC · Livermore, CAN6440DBurns John Michael III · San Mateo, CAN6440JGo Vertical Aviation LLC · Russellville, ALN6440PMcdonald Patricia Lynn · Westcliffe, CON6440RAir George LLC · Oblong, ILN6440WMckenney Robert N · Schertz, TXN64411Anderson Gregory S · Reedsville, PAN64413Hammerton Kenneth R · Olive Branch, MSN64414Skyhawk N64414 LLC · Walpole, MAN64418Mackey Jeffrey S · Dunlap, TNN6441DInter State Aviation Inc · Pullman, WAN6441FMach III Flying Inc · Platte City, MON6441JAnsell Nathan D · Mukwonago, WIN6441QMccready Steven Scott Trustee · Los Alamos, NMN64420Pelletier Kevin C · Fort Fairfield, MEN64421Celtic Flight LLC · Lewes, DEN64423Dsr-Cherokee 180 LLC · Dallas, TXN64427Teton Leasing LLC · Pocatello, IDN64429Pan Air Flying Club · Miami, FLN6442JDeberardinis Timothy P · Logandale, NVN6442PV & E Aviation LLC · Wisconsin Rapids, WIN6442QFord Jeremy · Las Vegas, NVN6442RAmmozon LLC · Gilbert, AZN6442UUpchurch David A · Graton, CAN64431Coordinated Flight Training LLC · Grain Valley, MON64433High Flight Academy LLC · Allison Park, PAN64438Wings For Witness Inc · Granger, INN64439Gertsen Ronald H · Glenwood, NJN6443JMcfarland Kenneth E · Kansas City, MON6443PCox William Matthew · Las Vegas, NVN6443RTangen Christopher M · Pequot Lakes, MNN6443URaw Aero LLC · Warsaw, MON64441Dramstad Flying Service LLC · Helena, MTN64442Goodspeed Air Services LLC · Oxford, CTN64447N64447 Series Of Moapa Valley Aeronautical LLC · Logandale, NVN64448Flying 20 Club Inc · Springfield, ILN64449Bedell Peter A · Church Hill, MD
Back to AD 87-10-06 R1