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.

N457ACBrown David R · Niceville, FLBuilt 1999 · S/N 414-99 N457AGSkywest Leasing Inc · St George, UTBuilt 2024 · S/N 2881757 N457ARPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010057 N457BCMorris Thomas Z Trustee · Spokane Valley, WABuilt 1974 · S/N 17264589 N457CFHelliwell Anne · Sun City, CAS/N 08 N457CMIasco Flight Training Inc · Redding, CABuilt 2000 · S/N 17280849 N457DHRichardson Justin · Glasgow, KYBuilt 1998 · S/N 20457 N457EPRainier Flight Service LLC · Renton, WABuilt 2015 · S/N 172S11593 N457FAHartfiel Joel T · Glenwood, IABuilt 1956 · S/N 457 N457FLApplebee Kevin · White Heath, ILBuilt 1971 · S/N 28-7125252 N457GHStephenson George B · Santa Fe, NMBuilt 2018 · S/N 72784 N457MCBoguy Air LLC · Kingstree, SCBuilt 1974 · S/N 466-74 N457PAIdeal Aviation Illinois LLC · Sauget, ILBuilt 2019 · S/N 1247 N457PMHordiienko Yurii · Boston, MABuilt 2018 · S/N 2108 N457RBHale Francis J III · Raleigh, NCBuilt 1990 · S/N 1457 N457SKWorld Marketing Syndicate I · Wilmington, DEBuilt 1975 · S/N 17264736 N457SPSouth Dakota State University · Brookings, SDBuilt 1999 · S/N 172S8321 N457TThompson Ernest W Jr · Yukon, OKBuilt 1976 · S/N 28-7690218 N457TCLangston Thomas G · Weatherford, TXBuilt 2014 · S/N 785 N4580FRegistered aircraftBuilt 1976 · S/N 28-7790045 N4580RMartin James E · Rostraver Township, PABuilt 1966 · S/N 28-21322 N4581JN634mm LLC · Pelham, ALBuilt 1968 · S/N 28R-30450 N4581XRegistered aircraftBuilt 1975 · S/N 28-7690042 N45829Registered aircraftBuilt 2004 · S/N 28020C N4582AHart Duane L Trustee · Wasilla, AKS/N 18-4888 N4582JTew-Mac Aviation · Tewksbury, MABuilt 1968 · S/N 28R-30451 N4582RMartin Robert T · Huntsville, OHBuilt 1965 · S/N 28-21324 N4582ZWriedt Dirk · South Beloit, ILBuilt 1961 · S/N 22-8091 N45832Arenal Patrick T · Granbury, TXBuilt 1977 · S/N 28-7890048 N45835Yoakam John A · North Ridgeville, OHS/N 177RG0756 N4583RDmac Aircraft LLC · Savannah, GABuilt 1965 · S/N 28-21325 N4583TKeppers Richard W · Alexandria, VABuilt 1972 · S/N 28R-7235099 N4583XMarquart Timothy Irving · San Antonio, TXFirst renewal noticeBuilt 1975 · S/N 28-7610037 N4584FStorm Flying Service Inc · Webster City, IAFirst renewal noticeBuilt 1976 · S/N 28-7790047 N4584JBradley Cody C · Auburn, NEBuilt 1968 · S/N 28R-30454 N4584RSiegel William G · Wellington, FLBuilt 1965 · S/N 28-21328 N4584ZCompton Michael · Crabtree, ORBuilt 1961 · S/N 22-8093 N4585XFrost Aviation Services Inc · Las Cruces, NMBuilt 1975 · S/N 28-7690043 N4586ALewton John · Belgrade, MTBuilt 1956 · S/N 18-4895 N4586RGuasch Walter L · Reno, NVBuilt 1965 · S/N 28-21330 N4586XMccardle Michael L · Houston, TXBuilt 1975 · S/N 28R-7635086 N4586YRiggin Flight Service Inc · Madison, SDBuilt 1967 · S/N 25-4264 N45870Gearhart Richard H · San Luis Obispo, CABuilt 1978 · S/N 3 N4587AChasing Alaska Corp · Anchorage, AKBuilt 1957 · S/N 18-4896 N4587TStory'S Aviation Services LLC · Webster, FLBuilt 1972 · S/N 28-7225194 N4588Smithenry Eric J · Newton, ILBuilt 1973 · S/N 671 N45888D-Five Holdings Group LLC · Vidor, TXBuilt 1963 · S/N 24-3453 N4588JSierra Hotel Fliers LLC · Lexington Park, MDBuilt 1968 · S/N 28R-30459 N4588LLewis Robert J · Carthage, NCBuilt 1984 · S/N 70 N4588TLeavitt James W · North Ferrisburgh, VTBuilt 1972 · S/N 28-7205189

Back to AD 81-18-04 R2