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.
N7330SNew Heights Aviation LLC · Decatur, TXN7330TBrazos River Aviation Group LLC · Mineral Wells, TXN73311184 Flying Club Inc · Concord, CAN73312Murray Air LLC · Patoka, ILN73317Bell Susan J · Georgetown, CAN73318Lair De Rien Aviation Inc Trustee · Wilmington, DEN73319My Way Aviation LLC · Weston, FLN7331AAviation 98374 LLC · Bonney Lake, WAN7331NLost Creek Aviation LLC · Elkhorn, WIN7331QKelly Timothy K · Dassel, MNN7331SAzizi Habib E · Franklin, TNN7331TRothenberger Stanley D · Topeka, KSN7331UBristol Bay Air Service Inc · Dillingham, AKN7331XPorter H Tom · Columbia, MSN73321Learn To Fly Nola LLC · New Orleans, LAN73324Gulf Atlantic Airways DBA · Gainesville, FLN7332MNorthern Flyers LLC · Bemidji, MNN7332SSmith Enterprises Inc · Grangeville, IDN73330Thornton Ralph · Oxford, ALN73331Dameron Cleveland F · Wicomico Church, VAN73334Heavy Metal Air LLC · Farmingdale, NYN73338Einarson Flying Service · Intl Falls, MNN7333FHickle William H · Inyokern, CAN7333QMac Neill Malcolm G · Lake Junaluska, NCN7333TMyl High Flying Club LLC · Mccall, IDFirst renewal noticeN73345N73345 Aviation LLC · Sheridan, WYN7334FWings Flight Enterprises Inc · Danville, KYN7334GEllis Gregory D · Winnsboro, TXN7334KFlying Wet Dog LLC · Marshall, TXN7334NRobles James J · Oro Valley, AZN7334QHurri-Clean LLC · Brewton, ALN7334SKcsi Aerial Patrol Inc · Bakersfield, CAN7334THunter Jeffrey D · Wolfforth, TXN7334XElliott Frank F · Mojave, CAN73354Sky Partners LLC · Sylacauga, ALN73357Aerospace Trust Management LLC Trustee · Wilmington, DEN7335APomeroy Keith R · Port Saint Lucie, FLN7335GJordan Jeffrey B · Woodland, WAN7335NEnrique Elias Luis · Chandler, AZN7335QStaas Justin W · Sacramento, CAN7335XTowery Katy L · Dover, DEN73361Snyder Steven S · Norfolk, VAN73362Spanaflight LLC · Puyallup, WAN73365Toliver David R · Lenexa, KSN73367Martinez Jose Antonio · Orlando, FLN7336ARanger Aviation Inc · Burlington, CON7336CDelta Kilo Av8 LLC · Bonita Springs, FLN7336HGerace William L · Anchorage, AKN7336MYates Christopher Lynn · Edmond, OKN7336NRoberts Frederick · El Segundo, CA
Back to AD 79-10-14 R1