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.

N29581Bas Part Sales LLC · Greeley, COBuilt 1968 · S/N 17700972 N29584Eagle Sky Patrol Inc · Deadwood, SDBuilt 1968 · S/N 17700974 N29585Ramold Corey M · Gretna, NEBuilt 1968 · S/N 17700975 N2958LStormo Jarrod M · Indianapolis, INBuilt 1967 · S/N 670092 N2958SSmith Jimmie A Trustee · Rose Hill, KSBuilt 1998 · S/N 23600 N2958XCooper Ronald C · Fowlerville, MIBuilt 1968 · S/N 17700358 N2958ZBryce Brad W · Lewis Center, OHBuilt 1959 · S/N 22-6931 N29592Reyner Matthew J · Georgetown, TXBuilt 1968 · S/N 17700978 N29593Else John J · Toledo, IABuilt 1968 · S/N 17700979 N29595Delta Fox Corp · Schaumburg, ILBuilt 1968 · S/N 17700980 N29596Murray Charles W · Reno, NVBuilt 1968 · S/N 17700981 N2959DWatson Frank H · Central Point, ORBuilt 1955 · S/N 26902 N2959GHubbert Stephen A · Newcastle, OKBuilt 1967 · S/N P-623 N2959LMcphillips Jess H · Port Arthur, TXBuilt 1967 · S/N 670093 N2959MHanneman Robert · Claremore, OKBuilt 1977 · S/N 28-7890281 N2959QParis Air Inc · Vero Beach, FLBuilt 1979 · S/N 28-7916585 N2959USmart5 LLC · Kissimmee, FLBuilt 1979 · S/N 28-7916588 N2959XCiochetti David · Kimberly, ORBuilt 1967 · S/N 17700359 N295ABFogerty Barry L · Shawnee, OKBuilt 2015 · S/N 23322 N295ACFanjoy James Michael · Nehalem, ORBuilt 1995 · S/N 756-95 N295BCWieler Jacob · Petty, TXS/N 28-7916435 N295BWWigglesworth Brad · Winnemucca, NVBuilt 1999 · S/N 3957 N295CMBesst John V · Lady Lake, FLBuilt 1979 · S/N 1424 N295DAJackson Construction LLC · Charleston, SCBuilt 1968 · S/N 28-24582 N295FSBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2018 · S/N 2844178 N295GSStine Scott · Vincennes, INBuilt 2026 · S/N 763 N295JFMartin Christian · Port Orange, FLBuilt 1991 · S/N 295 N295JJElliott Jimmy F · Hesston, KSBuilt 2024 · S/N 92215 N295KQSemenske John · Singer, WIBuilt 2019 · S/N 91660 N295LPWildridge Aviation LLC · Layton, UTBuilt 2003 · S/N 172S9295 N295MAStanton David M Jr · Kiawah Island, SCBuilt 1995 · S/N 2811040 N295MEWings Air Charter LLC · Wisconsin Rapids, WIBuilt 2000 · S/N 172S8553 N295PCFleming Charles R · Merritt Island, FLBuilt 2003 · S/N 54864 N295PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2022 · S/N 172S12871 N295PLAerospring Leasing LLC DBA · Wasilla, AKBuilt 2023 · S/N 172S13018 N295RSBeisert Nikolas · Penn Valley, CABuilt 1992 · S/N 002RS N295RWMac IV Aeroworks LLC · Saint Petersburg, FLBuilt 2002 · S/N 56 N295SBChagres Aero LLC · Albuquerque, NMBuilt 1979 · S/N 27-7954091 N295SRCarpenter William R · West Springfield, VABuilt 1994 · S/N 3213089 N295THendrickson Elisabeth A · Kerrick, MNBuilt 1953 · S/N 18-2409 N295TC295tc LLC · Cape Coral, FLBuilt 1996 · S/N 20012 N29604Farrington John R · Cedar Park, TXBuilt 1979 · S/N 28-7911182 N2960DRed Baron Rentals LLC · Jacksonville, FLBuilt 1979 · S/N 28-7916590 N2960PBrown Daniel A · Gettysburg, PABuilt 1955 · S/N 22-3233 N2960RVarun 2016 LLC · Florence, SCBuilt 1979 · S/N 28-7911275 N2960WDawson Ben J · Milton Freewater, ORS/N 1099 N2960YHudson Maury B · Humble, TXBuilt 1979 · S/N 32-7940230 N2960ZHuff Justin · Central, SCS/N 22-6934 N2961Wilbanks Kevin W · Artesia, NMBuilt 1972 · S/N 188967 N29610Ammar Elias G · Colton, CABuilt 1979 · S/N 28-7911183

Back to AD 81-18-04 R2