AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.
N6285SWindsor John R · East New Market, MDN6285TReasner David S · Moultonborough, NHN62862Freeflight Aviation LLC · Allentown, NJN6286SCunningham Doris DBA · East Freetown, MAN62875L&W Leasing LLC · Smyrna, TNN62876American Patrols Inc · Midland, TXN6287ARespess William Wallace III · Summerland Key, FLN6287EClemons Martin · Butte, MTN6287GPeters Guy P · Roy, UTN6287KWilliams Jimmy Z · Sherman, TXN62887Carter Jeffrey P · Parker, CON6288AMartin Joshua Keith · Rifle, CON6288DRickwalt David L · Fort Mohave, AZN6288EMccardy Derk · Torrance, CAN6288FAircraft Leasing And Service · Malabar, FLN6288GFetter Stanley B · Accokeek, MDN6288KCentral Virginia Aviation Inc · North Dinwiddie, VAN6288TGrote Bradley J · Torrington, WYN62890Fixed Wing Holding Co Inc · Pembroke Pines, FLN62891Wings Over Texas Holdings LLC · Denton, TXN6289DYecny Enterprises Inc · San Luis Obispo, CAN6289EMaverick Jets LLC · Vineburg, CAN6289FSbk Aviation LLC · Festus, MON6289KPitcock Randall · Farwell, TXN6289SLink Darryl B · Centennial, CON628CTAb Prop Plane II LLC · Metairie, LAN628DKEastgate Investments LLC · Henderson, NVN628FNFlying Neutrons LLC · Lebanon, OHN628JCDelaney Patrick James · Marion, TXN628LAAircraft Holdings LLC · Scottsdale, AZN628MAFitzgerald Brian B · Gettysburg, PAN628PDMessimer Joseph L Jr · Nacogdoches, TXN628RBBrown Michael C · Erie, KSN628RGKozubek Richard R · Shady Shores, TXN628TTTollen Troy J · Austin, TXN628YTAdventist World Aviation · Wilson, NCN62901Bates Field Aero Club Inc · Mobile, ALN6290EConnell Mark Stephen · Melbourne, FLN6290SFloyd Brannon A · Athens, GAN6290TLittlefield Molly F · Kent, WAN6290VDelta Sierra Aviation LLC · White Salmon, WAN62918Neron II LLC · New Smyrna Beach, FLN6291CSatl Ranch Aviation LLC · Midland, TXN6291EWright Robert D Trustee · Redding, CAN6291GWaddell Lucas A · Fort Worth, TXN6292ELucci Giacinto A Jr · Nashville, MIN6292RHynes Kevin P · Wichita Falls, TXN6292SAviation Trust Company LLC Trustee · Oklahoma City, OKN6292TLee Bryan L · Salinas, CAN62938Two Guys Aviation LLC · Idaho Falls, ID
Back to AD 79-10-14 R1