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.
N4737FJelm Gordon E · Aguila, AZN4737UMoody Properties LLC · Olympia, WAN4738BEarhart Robert E · Dallas, TXN4738GCmk Aerial Inc · Sutton, NEN4738QNeal Tyler W · Dufur, ORN4738USw Aviation Services Inc · Queen Creek, AZN4738XHageness Todd A · Rugby, NDN4739DMuddy Creek Aviation LLC · Dayton, VAN4739FEberwine David B · Lucas, TXN4739JVero Technical Support Inc · Pensacola, FLN4739XKimberly Jack L · Shippensburg, PAN473CAWingsleasing LLC · Wichita, KSN473CMN473cm LLC · Manassas, VAN473CSDae Aviation Enterprises Corp · Gilford, NHN473EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN473KPDuffys Aircraft Sales & Leasing Inc · Neillsville, WIN473YCU S Department Of The Interior · Boise, IDN4740BCallahan Brian L Trustee · Kuna, IDN4740EVehorn Richard B · Carrollton, TXN4740FSkydive Ricks LLC · Petersburg, OHN4740NGtz No 1 LLC · Kalispell, MTN4740QFitzpatrick D L III · Whitefish, MTN4741NCimmaron Flying Inc · Colorado Springs, CON4741XRessel Erik P · Lakewood, CON47428Nei Jeffrey G · Bemidji, MNN4742EHangen Mark C · Flagstaff, AZN4742NRegistration Pending · Wilmington, DERegistration pendingN4742UProtocol Enterprises LLC · Holdrege, NEN4742XMurphy Chong Yi · Fernandina Beach, FLN4743BAmstrup Norm D · North Pole, AKN4743CFour Three Charlie LLC · Andover, MAN4743DEss Partnership LLC · Waterford, MIN4743ERegistered aircraftN4743NGallagher Jeff · Rio Oso, CAN4743QHabersetzer Brian D · Brush Prairie, WAN4743XAerotech Mapping Inc · Las Vegas, NVN4744CDesert Aviation LLC · Kingman, AZN4744GJackson Flight Center LLC · Moses Lake, WAN4745DRoman Steven T · Burgettstown, PAN4745NHowze William Scott · Robstown, TXN4746NDenham Stacy L · Chehalis, WAN4746RZurawski Joseph · Ocala, FLN4746U4746u LLC · Sherman Oaks, CAN4747CAlfred Joseph T · Pagosa Springs, CON4747QRoss Andrew P · Romoland, CAN4748DLifting Spirits Research LLC · Pensacola, FLN4748JYecny Enterprises Inc DBA · San Luis Obispo, CAFirst renewal noticeN4748USmith-Heffernan Heather · Frisco, TXN4749BNunley Tim L · Palmer, AKN4749XFlaat Stephen C · Bemidji, MN
Back to AD 79-10-14 R1