Skip to content

Registered aircraft · 81,733

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.

N34850Axs Sourcing It LLC · Chugiak, AKBuilt 1973 · S/N 17702044 N34852Pride Electric Enterprises · Prescott Valley, AZBuilt 1973 · S/N 17702046 N34858Schmid Walter Allen · Fruitland, IDFirst renewal noticeBuilt 1973 · S/N 17702049 N3485WKemp James A · Deland, FLBuilt 1966 · S/N 32-363 N3485XCdm Flight Club Inc · La Jolla, CABuilt 1966 · S/N 1157 N3485ZVarco John M · Palmer, AKBuilt 1960 · S/N 18-7317 N34860Pittman Charles R Trustee · Waterloo, ILBuilt 1973 · S/N 17702051 N34865Schmedeman Andrew J · Sanford, FLBuilt 1973 · S/N 17702053 N34866Schroeder David C · Norfolk, NEBuilt 1976 · S/N 177RG1015 N34868Leonard Isaacs Aviation LLC · Fairfield, TXBuilt 1973 · S/N 17702056 N34869Aviation Advantage LLC · Phoenix, AZBuilt 1976 · S/N 177RG1016 N3486NRose Thomas Z · Santa Ana, CABuilt 1967 · S/N 680068 N3486RMorrissey David H · Queensbury, NYBuilt 1969 · S/N 28-5701 N3486WSteele Jackie L · London, KYBuilt 1966 · S/N 32-364 N3486XLaas Enterprises Inc · Warrens, WIBuilt 1966 · S/N 3423 N34873Payne Richard L · Flint Hill, VABuilt 1973 · S/N 17702058 N34876Clear Sky Flyers LLC · Lincoln, NEBuilt 1973 · S/N 17702059 N3487AOutka Wade R · Aberdeen, SDBuilt 1953 · S/N 22-1759 N3487MSchroeder Kenneth M Jr · Pinehurst, NCBuilt 1955 · S/N 12-2331 N3487QIsrael Jonathan · Huntington Beach, CABuilt 1977 · S/N 28-7716159 N3487XKrzeminski Paul A · San Carlos, CABuilt 1966 · S/N 3424 N34886Brooks Aviation LLC · Wilmington, DEBuilt 1974 · S/N 17702064 N34888Double J3 Aviation LLC · West Palm Beach, FLS/N 17702066 N3488ADanoff Michele A · Edgewater, MDBuilt 1952 · S/N 22-1760 N3488NValley Aviation LLC · Fargo, NDBuilt 1967 · S/N 680070 N3488WLiberty University School Of Aeronautics · Lynchburg, VABuilt 1966 · S/N 32-367 N3488ZBastian Richard L · Burns, WYBuilt 1960 · S/N 18-7325 N34891White Robert A · Washington, NCBuilt 1976 · S/N 177RG1018 N34894Whitney Ron · Indianapolis, INBuilt 1974 · S/N 17702070 N34896Kidron Flying Club Pll · Wooster, OHBuilt 1974 · S/N 17702071 N34897Loscheider Brian P · Cologne, MNBuilt 1974 · S/N 17702072 N3489AZgurich Joseph S · Irwin, PABuilt 1953 · S/N 22-1761 N3489KGfh LLC · Zillah, WABuilt 1967 · S/N 28-23582 N3489TBlue Skies Aviation LLC · Belfast, MEBuilt 1968 · S/N 17700789 N3489XHanson Jonathan · Palmer, AKS/N 1159 N348BPEks LLC · Lenoir City, TNBuilt 2001 · S/N 18077C N348CHAce Flight Center Inc · St Thomas, VIS/N 17266564 N348CPHaddock Tracey P · Kingstree, SCBuilt 1998 · S/N 17280348 N348DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843841 N348JMMelby Jon D · Chandler, AZBuilt 1997 · S/N 4002 N348JWHupp Patrick · Gladstone, MOBuilt 2001 · S/N 01JW N348KEEllwood Luke D · Springboro, OHBuilt 1998 · S/N 001 N348MAWilson Ralph W Trustee · Mentor, OHBuilt 2002 · S/N 1337-2002 N348MBClay David L · Bryceville, FLS/N 1662 N348MKNorth Star Aviation · Mankato, MNBuilt 2020 · S/N 2881418 N348PBAbu Trailers Inc · Dwight, NDBuilt 2011 · S/N 40978 N348PVVollheim Peter M · Nashua, NHBuilt 1984 · S/N 348 N348RPWright-Piros Ruth · Carlisle, IABuilt 1979 · S/N 32-7940186 N348RVBayani Amir · Roswell, GABuilt 2002 · S/N 81189 N348SAPutman James R Jr · Kernersville, NCBuilt 1974 · S/N 17702065

Back to AD 81-18-04 R2