Skip to content

Registered aircraft · 56,578

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

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

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.

N232ESBayside Beach Resort LLC · Tavernier, FLFirst renewal noticeBuilt 2005 · S/N 18281540 N232FFArq Aviation LLC · Wilmington, NCBuilt 2026 · S/N 172S13571 N232LSElliott Arthur M · Portland, TXBuilt 1971 · S/N 17260131 N232MEDunbar Joseph · Greensboro, NCBuilt 2000 · S/N 18280749 N232MTAir Force Life Cycle Management Center · Lexington, MABuilt 1981 · S/N U20606200 N232SBEagle Crest 2sb LLC · Milton, DEBuilt 1998 · S/N 18280211 N232ZVance Jordan Enterprises Inc · Wilmington, DEBuilt 2005 · S/N 18281627 N233Stone Scott Robert · New Waverly, TXBuilt 1968 · S/N 15068882 N23302Adams John C · Gladstone, MOBuilt 1968 · S/N 15068860 N23303Chuzy Suzy LLC · Lafayette, LABuilt 1968 · S/N 15068861 N23304Gendy Shady S · Columbia, PABuilt 1968 · S/N 15068862 N23305Fuhrmann Brandon R · Aberdeen, SDBuilt 1968 · S/N 15068863 N23308Hotel Bravo Aviation LLC · Sumrall, MSBuilt 1968 · S/N 15068864 N2330EManhattan Flying Tigers Inc · Bozeman, MTBuilt 1978 · S/N 17271236 N2330FFlight Operations Aircraft LLC · Wilmington, DEBuilt 2005 · S/N 172S9992 N2330GEmshwiller Mark E · Camp Verde, AZBuilt 1958 · S/N 51630 N2330XKeller Ronald B · Bosque Farms, NMBuilt 1965 · S/N 18256230 N23311Sweeney Daniel W · Broad Brook, CTBuilt 1968 · S/N 15068866 N2331DJensen William C · Brookshire, TXBuilt 1952 · S/N 20483 N2331FReeves Thomas W · Issaquah, WABuilt 1964 · S/N 21058531 N2331GSouth Bay Aviation Inc · Torrance, CAS/N 51631 N2331RSawicki Michael T · Midland, MIBuilt 1964 · S/N 18255431 N2331SMiller Randy L · Enid, OKS/N 337-0631 N23322Lopez William Alberto · Miami, FLBuilt 1968 · S/N 15068873 N23323Boccaccio Peter Anthony · Burke, SDBuilt 1968 · S/N 15068874 N23324Walden James F · Willcox, AZBuilt 1968 · S/N 15068875 N23328Scmitt Rudy · Brookshire, TXBuilt 1968 · S/N 15068876 N23329Welles Richard V · Elmira, NYBuilt 1968 · S/N 15068877 N2332CBalgoyen James T · Charlotte, MIBuilt 1954 · S/N 30632 N2332DSandstrom David · Anchorage, AKBuilt 1952 · S/N 20484 N2332EMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 17271238 N2332SLouisiana Military Museum · Abbeville, LAS/N 337-0632 N2332YAlbi Aero LLC · Denver, COBuilt 1967 · S/N 17700132 N23330N23330 LLC · Bedford, PABuilt 1968 · S/N 15068878 N23333Leading Edge Aviation LLC · Lewiston, IDBuilt 1968 · S/N 15068880 N23337Mosquito LLC · Chesaning, MIBuilt 1968 · S/N 15068883 N2333DTroutman Charles W · Prineville, ORBuilt 1952 · S/N 20485 N2333GRegistration Pending · Belen, NMRegistration pendingS/N 51633 N2333KAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N U20603676 N2333XHjr Aviation LLC · Reno, NVBuilt 1965 · S/N 18256233 N2333YSkillman Flying Services LLC · Brookshire, TXS/N 17700133 N23344Hmh Consolidated LLC · Lake Placid, FLBuilt 1968 · S/N 15068888 N23348Noel Tom W · Galloway, OHBuilt 1968 · S/N 15068890 N23349Fairwinds Aviation LLC · Goldsboro, NCBuilt 1968 · S/N 15068891 N2334DCaruso Timothy E · Gainesville, VABuilt 1952 · S/N 20486 N2334GHegna David E · Wall Township, NJBuilt 2005 · S/N 172S9994 N2334JThree Four Juliet LLC · Orange, CABuilt 2005 · S/N 172S9995 N2334USimplifly LLC · Mesa, AZBuilt 1962 · S/N 17249934 N23350Kimbrel Martin E · Oakville, WABuilt 1968 · S/N 15068892 N23353Weems Widener E · San Antonio, TXBuilt 1974 · S/N 17264085

Back to AD 79-10-14 R1