Skip to content

Registered aircraft · 81,728

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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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:81-18-04-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
  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:81-18-04-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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.

N254SRJets To Helis LLC DBA · Chandler, AZBuilt 2023 · S/N 4887 N254TFindlay Harald · Charlotte, VTBuilt 1953 · S/N 18-2368 N254VVBoney Grady · Rhine, GABuilt 2007 · S/N 1038-2007 N25502Hartman Dylin Erik · Ray City, GABuilt 1977 · S/N 15280698 N2550BSouthern Utah University · Cedar City, UTS/N 0611 N2550MEarthcom Inc · Williamston, MIBuilt 1977 · S/N 28-7816292 N2550PRobinson Mark V · Vacaville, CABuilt 1979 · S/N 38-79A1020 N2550YPramik Thomas J · Akron, OHBuilt 1985 · S/N 28-8516077 N25511Gleason Randy H · Redding, CABuilt 1969 · S/N 28-25718 N25514Renner Thomas J · Williston, NDS/N 15280708 N25517Suski Jeanne M · Tonawanda, NYBuilt 1978 · S/N 15280710 N25518Prather David W · Cameron Park, CABuilt 1977 · S/N 15280711 N2551PLimoge Jerome P III · Colorado Springs, COBuilt 1955 · S/N 22-2915 N2551UPizzuto Samuel J · Chamblee, GABuilt 1979 · S/N 28-8016034 N2551ZHobson Simon · Eagle River, AKBuilt 1977 · S/N 999-77 N25525Ferguson Carrie L · Palo Alto, CABuilt 1977 · S/N 15280716 N2552DKindred Heather · Dania, FLBuilt 1978 · S/N 38-79A0368 N2552MSchmidt Anthony D Jr · Jordan, MNBuilt 1946 · S/N 12-933 N2552WNahas Rafik E · Laguna Niguel, CABuilt 1965 · S/N 920 N2553MRubbert Jan D · Upham, NDBuilt 1946 · S/N 12-1012 N2553WBrown Jeffrey B · Punta Gorda, FLBuilt 1965 · S/N 3265 N2553YMacair Aviation LLC · Xenia, OHBuilt 1985 · S/N 28-8516079 N2554AWalker Michael K · Bartlett, TNBuilt 1952 · S/N 22-850 N2554MLensegrav Leslie C · Meadow, SDBuilt 1946 · S/N 12-1013 N2554WThomas Ryan · Carolina Beach, NCBuilt 1966 · S/N 1014 N25552Region Flyers LLC · Valparaiso, INBuilt 1985 · S/N 28-8516081 N25557All Aviation Xp LLC · Parkland, FLBuilt 1977 · S/N 15280729 N2555BHadden Fleming Cindy L · San Antonio, TXS/N 28-25678 N2555MSchiller Jeffrey A · San Diego, CABuilt 1946 · S/N 12-1011 N2555PJohnson Alwyn J · Karlstad, MNBuilt 1955 · S/N 22-2889 N25564Sunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15280732 N25567Ellingwood Kevin J · Williamstown, MABuilt 1977 · S/N 15280735 N2556AAllen Trace L · Hurricane, UTBuilt 1952 · S/N 22-853 N2556MTennyson Chad E · Ridgefield, WABuilt 1946 · S/N 12-1040 N25572Gruetzmacher Marcus Darren · Goliad, TXBuilt 1977 · S/N 15280738 N25573Adjoodani Farhad F · Glen Burnie, MDBuilt 1977 · S/N 15280739 N25575Pierce John S · Delevan, NYBuilt 1977 · S/N 15280741 N2557AHubbard Byron R · Cleburne, TXBuilt 1952 · S/N 22-855 N2557MSale Reported · Oklahoma City, OKSale reportedBuilt 1946 · S/N 12-934 N2557PMcmahon Thomas F · Yakima, WABuilt 1955 · S/N 22-2920 N2557WAndre Norman C · Downers Grove, ILBuilt 1965 · S/N 923 N25582Heavy Metal Air LLC · Farmingdale, NYBuilt 1977 · S/N 15280746 N2558LHoecher Robert · Anchorage, AKS/N 17255758 N25596Phelps Charles R · Princeton, KYS/N 38-81A0009 N2559AStefan Leon F · Nickerson, KSBuilt 1952 · S/N 22-857 N2559PSale Reported · Oklahoma City, OKSale reportedBuilt 1955 · S/N 22-2922 N2559STrue Altitude LLC · Isola, MSBuilt 1979 · S/N 18-7909160 N2559WHighfill Randall W · Hannibal, MOBuilt 1965 · S/N 3268 N255ATThompson Aaron R · Louisville, KYS/N 18280060 N255CBZions Credit Corp · Salt Lake City, UTBuilt 2020 · S/N 2881390

Back to AD 81-18-04 R2