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.
N79TNNaegle N W · Toquerville, UTN79VEIsocelestian Concepts LLC · Pelzer, SCN79VM3 Itg Aviation LLC · Allentown, NJN79WCElmer Wayne A · Battle Lake, MNN79WHMainland Michael L · Sarasota, FLN79WWWindward Aviation Inc · Puunene, HIN79ZTKirby Dennis T · Sandia Park, NMN7ACCommander Quest LLC · San Luis Obispo, CAN7AFN7af LLC · Ronkonkoma, NYN7AKScott Brian · Sherburn, MNN7AMGalluzzi Michael C · Edgewater, FLN7AZDevaney Aviation Inc · Palm City, FLN7BShaw David A · Palestine, ILN7CBExperimental Aircraft Association · Oshkosh, WIN7CEGerhardstein Gregory V · Friday Harbor, WAN7DHolliday Mark E · Lake Elmo, MNN7DGElizabeth City State University · Elizabeth City, NCN7DTPeet Edward V · Lady Lake, FLN7DWMeredith Mark S · Edgewater, MDN7DYTempleton James N · Petersburg, ILN7EHHalimi Timothy · Bell, CAN7ELRvbird LLC · Seattle, WAN7EYCharnwood Aviation Inc Trustee · Wilmington, DEN7FMAppalachian Racing Aviation LLC · Johnson City, TNN7FPBrooks David · Forney, TXN7FSCalvet David R · Millington, TNN7GVNewell Cody J · Ridgefield, WAN7HKEl Ghawi Andre N · Venice, FLN7HTJohns Aviation LLC · Dawson, GAN7HURoca Roja Y Caballo Gris De Idaho LLC · Meridian, IDN7HWAltieri Frank J · Somerton, AZN7HXBlairtogaii Inc · Novi, MIN7JBB F Service Inc · Bloomington, INN7JCJcmc Inc · Junction City, KSN7JESale Reported · Rogersville, MOSale reported, pending cancellationN7JJKarmel Moshe · Aventura, FLN7JVGreer Air Inc · Saint Cloud, FLN7KSilverman Kenneth Lack · Jefferson, NCN7KATurner Tim R · San Angelo, TXN7KRRegistration Pending · Prosper, TXRegistration pendingN7LLBautista Sean P · Reedley, CAN7LPFirth Leonard F · Navasota, TXN7LUNorber Howard S · Chicago, ILN7LXSalish Flyers LLC · Medina, WAN7LZSpringer Bradley C · Othello, WAN7MAWelsh Jonathan D · Montclair, NJN7MDReady Aim Flyer LLC · New Castle, DEN7MUAerospace Trust Management LLC Trustee · Wilmington, DEN7MYParis Enterprises LLC · Wilmington, DEN7NTTaylor Margaret L Trustee · Ontario, OR
Back to AD 87-10-06 R1