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.
N944BALatitude 18 Helicopters LLC · Lewes, DEN944CBCalifornia Baptist University · Riverside, CAN944CDFlying Easy LLC · Jacksonville, NCN944DPFulton Mark · Elkhorn, NEN944EVSouthlake Aviation LLC · Arden, NCN944GGraves Charles M · Phoenix, AZN944JKRegistered aircraftN944KMMartin Rick H · Las Vegas, NVN944LC4lc LLC · Mcminnville, ORN944MRegistered aircraftN944MALjmf 17 LLC · Hays, KSN944PCAlba Leasing Services LLC · Phoenix, AZN944RRancifer Rodney M · Lithonia, GAN944RRJaybee Aviation Ltd · Fort Mill, SCN944SJ & J Aviation LLC · Kokomo, INN944SHA & E Aerial LLC · Nashville, ARN944SJMiller David D · Plainfield, ILN944TDiedrick Michael R · Brooksville, FLN944VCoastal 944v LLC · Wilmington, NCN944WMMcinerney James William · Park Ridge, ILN944WTHolt Helicopters Inc · Uvalde, TXN9450DSharabi Avinoam · Las Vegas, NVN9450PSmh Aviation LLC · Dallas, TXN9450WAirwide LLC · Deerwood, MNN9451JJackson James E · Denair, CAN9451NHorus Aviation LLC · Ashburn, VAN9452CFarris James R Jr · New Castle, PAN9452EDew Jason L · Krum, TXN9452HFreeland Thomas W · Early, TXN9452PRegistered aircraftN9452VFriesen Dwayne Phillip · Overton, TXN9452WMarshall Duane C · Rossville, TNN9453JStarbard Donald · Crystal Bay, NVN9453NBroody George E Jr · Berwick, PAN9453PWhitehead Dennis C · Iron Mountain, MIN9453VNavflight Inc · Fort Worth, TXN9453WLifetime Aviation Services LLC · Muncie, INN9454CPuglia Frank V · El Cajon, CAN9454PJohnson Roger D · Fort Meade, FLN9454SStoddart Bruce K · Brighton, MIN9455Sessions Richard T · Houston, TXN9455NSchreiber Jeffrey H · Mundelein, ILN9456DMajka Marc · San Carlos, CAN9456MDickey Brandon · Willow, AKN9456VSnover Darryl A · Cherryville, PAN9456WEngwis Douglas R · Rhodes, MIN9457DN1705r Inc · Cobb, CAN9457NHermes Aviation Partners LLC · Boca Raton, FLN9457PN84dt LLC · Missoula, MTN9457WMast Henry V · Dayton, TX
Back to AD 87-10-06 R1