AD 75-16-10
Registered aircraft · 2,695
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:75-16-10')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-16-10')
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:75-16-10') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-16-10') 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.
N119TWCarter Flygare Inc · Sacramento, CAN11ACN11ac LLC · Lighthouse Point, FLN11ECBasler Turbo Conversions LLC · Oshkosh, WIN11EVBonita Beech LLC · Bonita Springs, FLN11FFJet Speed Aviation Inc · Las Vegas, NVN11KFRebel Dawg Aviation LLC · Vestavia Hills, ALN11SCHarrington John M · Payson, AZN11SYRautiola Erik · Cresson, TXN11VKHoskins Terry Wayne II · Knoxville, TNN11YPDanforth Equipment LLC · Leesburg, FLN1202BDavis Aviation Inc DBA · Brandon, MSN1208ZMaurice L Prince Jr Pc · Lafayette, LAN120BSkysuite Aviation LLC · Tujunga, CAN1215TShepphird John C · Reno, NVN121AFEway William · Jupiter, FLN121BWLester Jon M · Lancaster, OHN121LGPayton Kathleen · Grand View, IDN1223Z2dwh LLC · Katy, TXN122BRHollon Blake D · Douglas, WYN122CTTurner Eye Clinic Inc · Cabot, ARN122PGMcgaw Thomas D · Petaluma, CAN122RLJenaero LLC · Cincinnati, OHN122RMHolland Mark Drew · San Antonio, TXN123AKOptima Aviation LLC DBA · Lewisville, TXN123GBRegistered aircraftN123JJRotorwings Aviation LLC · Hebron, NEN123USLow Gary Mike · Southside, ARN123WBHighview LLC · Brentwood, TNN1244YBurbank Dennis · Arcadia, OKN124AWCyalco Aviation LLC · Spencer, IAN124BZFerguson Steven L · Rawlins, WYN124TJAlan Aviation LLC · Los Angeles, CAN124VLeach Manuel R · Natchitoches, LAN125BEGomez Eliud · Winter Park, FLN125EMoir Jeffery K · Newhall, CAN1265ZGertsen Ronald H · Glenwood, NJN1268ZTodd Cori L · Gladewater, TXN1269ZChilds Lowell R · Elgin, ILN127FCalifornia In Nice Inc · San Jose, CAN127RWWindmiller David · Melville, NYN1284ZDubose Alexander R · Durham, CAN1285ZRivera Luis Jr · Spring, TXN128KJm Lavore Aero Inc · Lakeside, MTN128WSSkyway Air Taxi LLC · Manassas, VAN1299ZWojdac David E · Mosinee, WIN129QFlying J Aviation Pllc · League City, TXN129STAzell LLC · Springfield, MON12BGFull Scale Aviation LLC · Mccordsville, INN12BUVan Liew Bradford · Johns Island, SCN12DKTim Cross Aviation LLC · Tucson, AZ
Back to AD 75-16-10