AD 95-26-13
Registered aircraft · 21,464
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:95-26-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-26-13')
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:95-26-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-26-13') 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.
N1512X4js Inc DBA Great Country Motors · Sun City, AZN15132Lewis University · Romeoville, ILN15134Roe Robert D Jr · Naples, FLN15137Cart Caleb L · Eunice, LAN1513TLagemann Jeffrey P · Cocoa, FLN1513XTurner Gary H · Big Stone Gap, VAN15140Anthony J Cariotte Jr · Holbrook, NYN15141Murphy Jeffrey S · Mechanicsburg, PAN15142Dj Aviation LLC · Rio Vista, TXN15148Brown Jerry Keith · Calera, ALN1514JBooher Greg F · Livingston, TNN1514TTucker David J · Welch, OKN1514XRabidou Gary R Jr · Lancaster, MAN15151Smith Jared · Allendale, ILFirst renewal noticeN15152Meyer Kendra · Ankeny, IAN15153Kyzer Stacey A · Fort Mill, SCN15159Piper One Five Niner Inc · Greenville, WIN1515JMendenhall William R II · Beebe, ARN1515TSussman Steven T · Goshen, NYN15160Western Aire Flying Club Ltd · Sparta, WIN15169Stephens Brennan · Irving, TXN1516JH&H Holding LLC · Tucson, AZN15171Eckler David L · New Hudson, MIN15172Transit William B · Macomb Township, MIN15176St Germain Joseph Ronald · Glenview, ILN15177Air Craft Enviromental Sys Inc · Hilton, NYN15179Henson Ricky T · Covington, TNN1517JPardiac Kenneth R · Howell, MIN1517XDippolito Thaddeus M · Sherwood, ARN15190Coastal Air · Groton, CTN15191Lumpp John R · Old Brookville, NYN15198Kehl Bryan R · Moorpark, CAN1519XAycd LLC · Allentown, PAN151AV51st Aero Squadron LLC · Hoover, ALN151CHGharazeddine Raja · Kaplan, LAN151DJValley City Flying Club Llp · Valley City, NDN151DLBd Aviation LLC · Sauget, ILN151DSCastro Salvador A · Houston, TXN151GAtp Aircraft 9 LLC · Wilmington, DEN151LHFarmingdale State University · Farmingdale, NYN151MMBas Part Sales LLC · Greeley, CON151SFRomeo-3 Aviation LLC · Marietta, GAN15200Cash Warren A · Loveland, CON15201Quaintance Kemper A · Culpeper, VAN15203Hummel David R · Cedar Falls, IAN15204Arthur Jeffery L · Lima, OHN15207Tiburon Aviation LLC · Tampa, FLN15208Colorado Northwestern Community College · Rangely, CON1520TAaa Aero LLC · Glenwood, MNN15219Shoup Michael D · Pierre, SD
Back to AD 95-26-13