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.

N5104TConsolidated Aviation Services LLC · Seymour, TNBuilt 1966 · S/N 496 N5104ZGary L Morton · Palmer, AKBuilt 1961 · S/N 22-8740 N5105MAscend Aviation LLC · Bountiful, UTBuilt 1980 · S/N 15284499 N5105QBailey Glenn E · Oldenburg, INBuilt 1973 · S/N 17261749 N5105RSale Reported · Colville, WASale reported, pending cancellationBuilt 1974 · S/N MB-639 N5105SSyphers Harold A · Aguila, AZBuilt 1971 · S/N 28-7125335 N5105TRider Charles A · Kokomo, INBuilt 1966 · S/N 502 N5105VOrr Samuel L · Cleveland, GABuilt 1958 · S/N FP-5 N5105WVroman Kiersten · Fort Edward, NYBuilt 1961 · S/N 28-122 N5105XManairco Inc · Wooster, OHBuilt 1969 · S/N 150 N5105ZKrumm Melvin L · Allegan, MIBuilt 1961 · S/N 22-8741 N5106BBabcock Lori A · Salina, KSBuilt 1979 · S/N 15283747 N5106HMartinez Patrick F · Palmer, AKBuilt 1948 · S/N 14-111 N5106LArnold John D · Reno, NVBuilt 1967 · S/N 28-4376 N5106RBenson Robert W · Wichita Falls, TXS/N MB-640 N5106ZDorsey James P · Bainbridge Island, WABuilt 1961 · S/N 22-8746 N51070Rabbit Hill Industries Inc · Bedford, NYS/N 17274262 N5107BWest Valley Flying Club · Palo Alto, CABuilt 1979 · S/N 15283748 N5107HFlyit LLC · Camas, WABuilt 1975 · S/N 17265342 N5107LSmith Jeremy · Houston, TXBuilt 1967 · S/N 28-4389 N5107MBahus Jason · La Porte, INBuilt 1978 · S/N M-2027 N5107NChristiansen Aviation LLC · Wilmington, DEBuilt 2009 · S/N 172S10924 N5107SJdc Aviation LLC · Upland, CABuilt 1971 · S/N 28R-7135108 N5107TIron Horse Leasing LLC · Platteville, WIS/N 28R-7235192 N5107VEckert Robert E · Edgewood, TXBuilt 1959 · S/N FP-7 N5108JHembree Ricky · Rockwall, TXBuilt 1980 · S/N 17273705 N5108LHellix LLC · Charlotte, NCS/N 15284266 N5108VDavis John K · Texarkana, ARBuilt 1959 · S/N FP-8 N5108WJennings Todd R · Hawthorne, FLBuilt 1961 · S/N 28-125 N5109BOverlander Aviation LLC · Palo Alto, CABuilt 1979 · S/N 15283750 N5109GSnamiska Kyle · Cypress, TXBuilt 1967 · S/N 28-23174 N5109SBucek James A · Baytown, TXBuilt 1971 · S/N 28-7105129 N5109XHarkema James P · Troy, OHBuilt 1969 · S/N 663 N510BLWingsleasing LLC · Wichita, KSBuilt 2025 · S/N 2881852 N510BNHyannis Air Service Inc DBA · Hyannis, MABuilt 1991 · S/N 2239 N510CMFlanagan John F · Eagle, IDBuilt 1994 · S/N 3117 N510DYoungs Water Conditioning Of Logansport LLC · Logansport, INS/N 27-7654024 N510DDSchardt Donovan D · Juniata, NEBuilt 2011 · S/N 40099 N510DFDunkle Steven P · Newnan, GABuilt 2022 · S/N 42271 N510DSTrussler Leslie Henley · Manchester, TNBuilt 2002 · S/N 40.210 N510FAEndeavour Flight Training Inc · Opa Locka, FLBuilt 1976 · S/N 17268470 N510FHCoco Aircraft Inc · Merritt Island, FLBuilt 1989 · S/N 2841179 N510GN510g LLC · Venice, FLS/N 660-320-404FB N510HRBrian Investments LLC · Elizabethtown, NCBuilt 1998 · S/N 4223-4 N510KSNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282177 N510LPSouthern Cross Aviation LLC · Parker, AZBuilt 2003 · S/N 172S9510 N510LSRegistration Pending · Nashville, TNRegistration pendingBuilt 2002 · S/N 899-2002 N510MEdwards Christopher A · Warrenton, VABuilt 1971 · S/N 1171 N510MARegistered aircraftBuilt 2005 · S/N 2322 N510NDSunrise Aviation Inc · Ormond Beach, FLBuilt 2010 · S/N 172S10952

Back to AD 81-18-04 R2