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.

N4534RDuwelius Charlotte Sue DBA · Hermiston, ORBuilt 1965 · S/N 28-21238 N4534TSunrise Aviation Inc · Ormond Beach, FLBuilt 1972 · S/N 34-7250127 N4534VSammons Ryne William · Bargersville, INBuilt 1979 · S/N AA5B1264 N4534X4534xray Flyers Ltd · Lima, OHBuilt 1975 · S/N 28R-7635071 N4534ZKay Bennie L · Brigham City, UTBuilt 1960 · S/N 22-8039 N45359Clapp Edwin G III · Fargo, NDBuilt 1976 · S/N 177RG1112 N4535DFrancis Mark D · Holden Beach, NCBuilt 1979 · S/N AA5B1267 N4535JMooney Executive Partnership · Kent, WABuilt 1968 · S/N 28R-30394 N4535LCratz33 LLC · Cincinnati, OHBuilt 1979 · S/N AA5B1269 N4535TCrews Joseph G · Cleveland, MSBuilt 1971 · S/N 28-7105222 N4535VSanders Aviation LLC · Boerne, TXBuilt 1979 · S/N AA5B1272 N45362Morrow Rodney T · Yorktown, INBuilt 1979 · S/N AA5B1287 N45367Christensen Robert T · Presho, SDBuilt 1976 · S/N 177RG1113 N4536BHolsten Guy V · Mineral, VABuilt 1979 · S/N AA5B1276 N4536JSale Reported · Merrill, WISale reportedBuilt 1968 · S/N 28R-30395 N4536LFlorence Glen A · Shelby Township, MIBuilt 1979 · S/N AA5B1280 N4536PPastuszenski Wayne · Austin, TXBuilt 1979 · S/N AA5B1281 N4536RRoesler Robert D · Gordonsville, VABuilt 1965 · S/N 28-21240 N4536TSherrod Roger F · Orlando, FLBuilt 1979 · S/N AA5B1284 N4536VReese Thomas R · Marathon, FLBuilt 1979 · S/N AA5B1286 N4536WAlger Michael · Umatilla, FLBuilt 1976 · S/N 13046 N4537NWeigand Robert A · Arcadia, FLBuilt 1979 · S/N AA5B1289 N4537TRussell Brice S · Milton, MABuilt 1971 · S/N 28-7105229 N4537VAir Land And Sea Inc · Brewerton, NYBuilt 1979 · S/N AA5B1291 N45385Steklenski Philip G · Olympia, WABuilt 1977 · S/N 177RG1117 N4538AHughes William L · Fort Worth, TXFirst renewal noticeBuilt 1956 · S/N 22-3847 N4538EGrasshopper Flying Club Inc · Poughkeepsie, NYBuilt 1978 · S/N 17271623 N4538GAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 2009 · S/N 2036 N4538NN4538n LLC · Spring Lake, MIBuilt 1979 · S/N AA5B1296 N4538QFlying V LLC · West Berlin, NJBuilt 1977 · S/N 28-7790476 N4538TLarsen Jeffrey A · Spokane Valley, WABuilt 1972 · S/N 28-7205190 N4538XHicks Paul · Greenfield Center, NYBuilt 1975 · S/N 28-7625051 N4538YKnutson Wayne R · Thompson, NDFirst renewal noticeBuilt 1967 · S/N 25-4184 N4539Raymer Michael K · Alma, ARS/N 1002 N4539ASvenningsen Joshua J · Menomonie, WIBuilt 1956 · S/N 22-3848 N4539LTempin Alan Martyn · Woodstock, ILBuilt 1979 · S/N AA5B1300 N4539PMolnar William J · Janesville, WIBuilt 1979 · S/N AA5B1301 N4539SMask Rickey D · Denison, TXBuilt 1979 · S/N AA5B1304 N4539VMinto Victoria L · Omak, WAS/N AA5B1305 N4539WWjordan & Co LLC · New Fairfield, CTBuilt 1976 · S/N 13049 N4539X4539x LLC · Saint John, INBuilt 1975 · S/N 28-7615026 N453CMUniversity Of Central Missouri · Warrensburg, MOBuilt 2000 · S/N 17280845 N453DBAguirre-Y-Luker Grant Climaco · Guthrie, OKBuilt 2012 · S/N 01 N453EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12645 N453HCRegistration Pending · Wasilla, AKRegistration pendingBuilt 2005 · S/N 001 N453HZBerger Michael B · Washington Island, WIS/N 453 N453KBPashkevich Michele · Pine Bluff, ARBuilt 1989 · S/N 1015 N453KCBryant Brothers Aviation LLC · Saint Marys, OHBuilt 1995 · S/N 3246015 N453LPFrsp LLC · Watkins, COBuilt 1999 · S/N 18280453 N453MKNorth Star Aviation · Mankato, MNBuilt 2024 · S/N 4496579

Back to AD 81-18-04 R2