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.
N8346HAir Jay West LLC · Winnetka, CAN8346LJones Mark B · Angleton, TXN8346NFleetcraft Transportation LLC · Naperville, ILN8346PPhelps Michael J Trustee · Oneida, TNN8346STravel Express Aviation LLC · West Chicago, ILN8346TMoradi Mark M · Orlando, FLN8346VLovley Linda C · Jordan, MNN8346WBurns C R · Huntsville, ALN83473Mccarthy Robert F · Purchase, NYN83476Mcmillan Gary · Frankston, TXN8347CTriple R D2 Jmw Corp · Saint Cloud, MNN8347DLewis David I · Atwater, OHN8347LSchye Ted E · Billings, MTN8347WKirk Kevin J · Pulaski, PAN83480Kloker Daniel E · Owasso, OKN8348GChelmsford Flyers LLC · Chelmsford, MARegistration ineffective or invalidN8348HRogers Gary J · Massapequa, NYN8348LPrice William B · Lamar, SCN8348MWings Over Texas Holdings LLC · Denton, TXN8348PEchols Mark R · Diana, TXN8348RMorris Jeff L · Radcliffe, IAN8348WAmerican Equipment Sales Inc · Lawrence, KSN8348YNelson Brian · Wakefield, NEN83494Knutson Wayne R · Tioga, NDN83497Popov Chris · Hope, IDN8349EArment C Randall · Valentine, NEN8349JCherry Michael A · Winchester, ILN8349PPickett Douglas M · Romeo, MIN8349RCsi Flight Services LLC · Mcminnville, ORN8349TStefan Terrence J · Dodge City, KSN8349WGrayhawk Flight Training LLC · Lucas, TXN834ATDot Aviation LLC · Wilmington, DEN834DVVeith Donald C · Cattaraugus, NYN834KTChambers Garland M · Roanoke, VAN834NDUnd Aerospace Foundation · Grand Forks, NDN834SHSmith Helicopters Inc · Cotulla, TXN834SSEastern Shore Helicopters Inc · Labelle, FLN834TFAir Fleet Holdings LLC · Missoula, MTN834TTFerreira Mario · New Bedford, MAN834WVVarnedoe Wyman E · Monument, CON8350MVortex Leasing LLC · Racine, WIN8350RPerinoni Edward Jr · Novato, CAN8350WJr Aviation Holdings LLC · Newark, DEN8351Zeller Francis J · Rosamond, CAN83516Airo LLC · Belmont, WIN8351LPlane Junkies LLC · Dover, DEN8351NDel Rio Aviation Inc · Paso Robles, CAN8351PComanche Air Holdings LLC · Austin, TXN8351WQuality Aero LLC · East Aurora, NYN83524Curtis Blake B · Clovis, NM
Back to AD 87-10-06 R1