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.

N484EPureflight Aviation Training LLC · Newberg, ORBuilt 2023 · S/N 1321 N484ERWisconsin Aviation-Four Lakes Inc · Madison, WIBuilt 2001 · S/N 172S8944 N484FLSmith Stephen A · Erwinna, PABuilt 1971 · S/N 28-7125292 N484JBSilver Creek Aviation Services · Fort Worth, TXBuilt 2008 · S/N 20608314 N484JLAustin Peay State University · Clarksville, TNBuilt 2023 · S/N 1325 N484JWAims Community College · Greeley, COBuilt 2025 · S/N 2881862 N484MSuper Bee LLC · Lino Lakes, MNBuilt 2009 · S/N 82643 N484MLLoree Steve J · Placerville, CABuilt 2007 · S/N ML001 N484NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2023 · S/N 2881667 N484PPrickett Jonathan L · Austin, TXBuilt 1965 · S/N 28-21077 N484SHNovember Alpha LLC · Dover, DES/N 10678 N484TCTrl Aviation LLC · Wichita, KSBuilt 2010 · S/N 40222 N484VMLake John K · Park City, UTBuilt 2005 · S/N 001 N484WBRegistration Pending · Kansas City, MORegistration pendingBuilt 2004 · S/N 10549 N48500R&R Aero Services LLC · Eden Prairie, MNBuilt 1977 · S/N 15280914 N4850BRoehrig James R Jr · Indianapolis, INBuilt 2011 · S/N 90055 N4850EGibson Timothy A · Frankfort, KYBuilt 1959 · S/N 7GC-47 N4850GPeters Walter C · Rockford, ILBuilt 1979 · S/N 17273397 N4850HGreen Airport Development Corp · Kemah, TXBuilt 1979 · S/N 15283985 N4850LUpper Airway Aviation LLC · Sonora, CABuilt 1967 · S/N 28-4199 N4851BCode Supplies Inc · Lakeland, TNBuilt 1979 · S/N 15283673 N4851GEye Candy Aviation LLC · Jacksonville, FLBuilt 1979 · S/N 17273398 N4851LCherokee Flyers LLC · Randolph, WIBuilt 1967 · S/N 28-4200 N4851PTwin Air Assets LLC · Casper, WYBuilt 1961 · S/N 27-424 N4851TWillis Gary B · Willis, TXBuilt 1972 · S/N 28-7205207 N4851ZNorris Randal E · Cambridge, KSBuilt 1961 · S/N 22-8426 N48521Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1979 · S/N 15283346 N4852AHanrahan Andrew D · Soldotna, AKBuilt 1956 · S/N 22-4005 N4852GR&R Aero Services LLC · Eden Prairie, MNBuilt 1979 · S/N 17273399 N4852LMohle Darren H · Carlsbad, CABuilt 1967 · S/N 28-4201 N4852PGreenwood Auto LLC · Itta Bena, MSBuilt 1980 · S/N 15284831 N4852TDeloach Stephen T · Brentwood, TNFirst renewal noticeBuilt 1972 · S/N 28-7205208 N4852VR & R Aviation Services LLC · Darien, ILS/N 172RG0400 N4853Stoltz Michael A · Portland, ORBuilt 1971 · S/N GK-3 N4853LSipos Henry A · Huntington Beach, CABuilt 1973 · S/N AA1B-0110 N4853PSwan Aviation Ministries Inc · Baker, FLS/N 27-426 N4853STurley Gregory D · Pell City, ALBuilt 1977 · S/N 870625 N4853ZPileggi James B · Berkeley, CABuilt 1961 · S/N 22-8428 N48549Davies Richard E · Sequim, WABuilt 1979 · S/N 15283349 N4854GMilwaukee Aero LLC · Milwaukee, WIBuilt 1979 · S/N 17273401 N4854JTrio Bravo Ltd · Hudson, OHBuilt 1968 · S/N 28R-30611 N4854LBarnes Doyle W · Glen Carbon, ILBuilt 1967 · S/N 28-4203 N4854XGrundmeier Patrick B · Gilbert, AZBuilt 1971 · S/N 287205040 N4855GWings Over Texas Holdings LLC · Denton, TXBuilt 1979 · S/N 17273402 N4855LEagle Sky Patrol Inc · Deadwood, SDS/N 28-4204 N4855TVaitai Rei LLC · Spring, TXBuilt 1972 · S/N 34-7250159 N48568Spartan Education LLC · Tulsa, OKBuilt 1979 · S/N 15283350 N4856AManning Travis J · Reno, NVBuilt 1956 · S/N 22-4012 N4856DOlsen Ernest D · Lino Lakes, MNBuilt 1979 · S/N 17272374 N4856ERiggin Flight Service Inc · Madison, SDBuilt 1959 · S/N 7GC-48

Back to AD 81-18-04 R2