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.
N8379SAir Dakota Flite Inc · Hettinger, NDN837CPCivil Air Patrol · Maxwell Afb, ALN837DDKleeman Thomas J · Cooper Landing, AKN837GACampbell Stephen V · Farmingdale, NYN837KSKansas State University · Salina, KSN837LAVolar Xi LLC · Edmond, OKN837SPIsrani Vijay · Cupertino, CAN8380ALynch Henry D · Hebron, NHN8380BShull Thomas A · Copper Center, AKN8380UTrp Enterprises Inc · Mocksville, NCN8381BRaymond Kyle Inc · Eagle, CON8381LShielded Holdings LLC - Series Av 12 · Katy, TXN8381SUer LLC · Searcy, ARN8381TMapes Peter B · Oscoda, MIN8381UFuryious Aviation LLC · Bossier City, LAN8381ZVoran Carlon R · Port Alsworth, AKN8382BDevore Plane Affects Lp · Independence, KSN8382GArneson Kenneth W · Beaverton, ORN8382JHouseknecht Thomas · State College, PAN8382LMedina Solla Edwin O · Trujillo Alto, PRN8382SFitzwater Richard B · Athol, IDN8383BSpears Franklin L · Lebanon, KYN8383MKessler Aviation LLC · Lansing, WVN8383QThompson Gordon H · Anchorage, AKN8383UBuzby Justin T · Wasilla, AKN8384GWoodall Steve W · Penngrove, CAN8384JKondol Andrlej J · Maspeth, NYN8384M1st Clev-Mar LLC · Gainesville, TXN8384XVehrs Roger K · Roseburg, ORN8385BTkn Holdings LLC · Pima, AZN8385JJones Stanley E · Vallejo, CAN8385LKrebs Lisa Christine · Homer, AKN8385UClow Streeter M · Mansfield, OHFirst renewal noticeN8385ZHoneysett Robert E Jr · Anchorage, AKN8386ATwo Flyers LLC · Wilmington, DEN8386GIndy Hot Air LLC · Westfield, INN8386JMyers Raymond R · Deer Park, WAN8386LAdams Haidyn · Pentwater, MIN8386M213tz LLC · Hailey, IDN8386QLe Tourneau University · Longview, TXN8386SDavis Lawrence R · Kent, OHN8386XSchool Board Of Leon County Florida · Tallahassee, FLN8387GAir Land And Sea Adventures LLC · West Palm Beach, FLN8387LSerra Christopher R · Snellville, GAN8387URegistered aircraftN8388AHamm Simon P · Denali, AKN8388BTouch And Go Inc · Center, CON8388JCunningham Kevin M · Alexandria, MNN8388MGreater Chattanooga Aviation Club LLC · Chattanooga, TNN8388SRose Mary R · Portland, OR
Back to AD 79-10-14 R1