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.

N4774FIlmberger Stephen J · Bend, ORBuilt 1979 · S/N 17273079 N4774JAlbin John B · Milan, MIBuilt 1967 · S/N MA-192 N4774PCannan Aviation Inc · Georgetown, TXBuilt 1980 · S/N 15284813 N4775LWadkins Chris H · Plummer, IDBuilt 1967 · S/N 28-4109 N4775PRegistered aircraftBuilt 1975 · S/N 20675 N47764Wl Aviation LLC · Olney, MDBuilt 1977 · S/N 32R-7880021 N47767Capps Clinton Wyatt · Navasota, TXBuilt 1977 · S/N 28-7816132 N47768Registered aircraftBuilt 1977 · S/N 28-7816133 N4776EAlpha One Aviation LLC · Dunedin, FLBuilt 1978 · S/N 17271641 N4776JKimbrough Paul E · Millcreek, UTBuilt 1967 · S/N MB-221 N4776LHitt John C · Plano, TXBuilt 1967 · S/N 28-4110 N4776THigh Planes Air Service · Bismarck, NDBuilt 1981 · S/N R18201762 N47773Walo Barry F · Cresson, TXBuilt 1977 · S/N 28-7890137 N4777HMorey Airplane Co Inc · Middleton, WIBuilt 1979 · S/N 15283978 N4777JHowell Michael A · Parsons, KSBuilt 1967 · S/N MB-224 N4777LRoss Charles B · Anchorage, AKBuilt 1967 · S/N 28-4111 N4777SN4777s LLC · Ault, COBuilt 1980 · S/N R18201424 N4778EClemmons Flyers LLC · Green Cove Springs, FLS/N 17271643 N4778LGarrett Russell K · Hazen, NDS/N 28-4112 N47791Schwartz John E · Ventura, CABuilt 1979 · S/N 15283250 N4779TAmerican Aerial Patrol LLC · Saint Amant, LABuilt 1981 · S/N R18201764 N477ALSimply Living LLC · Fort Myers, FLBuilt 1969 · S/N 17701285 N477AMSpicher Samuel C Jr · Groveland, FLBuilt 2021 · S/N 28020017 N477BGParker Dennis A · Charlevoix, MIBuilt 1977 · S/N AA5A0364 N477CHCsi Flight Services LLC · Mcminnville, ORBuilt 2004 · S/N 3729 N477CMCanin Daniel G · Palmdale, CABuilt 2003 · S/N 3206 N477DCChildress David W · Coldwater, MSBuilt 2007 · S/N 70717 N477DKPhilippi Ranches Inc · Hermiston, ORS/N 2160 N477EE477ee LLC · Bethany, OKBuilt 2023 · S/N 172S12954 N477GFState Of Alabama Department Of Conservation · Montgomery, ALBuilt 2018 · S/N 18283055 N477GYGolf Yankee LLC · Haymarket, VABuilt 2024 · S/N 18283265 N477LLLima Lima LLC · Lander, WYBuilt 1968 · S/N 18-8755 N477LMStampley Michael C · Mount Pleasant, SCBuilt 1965 · S/N 643 N477MERegistration Pending · Webster, NYRegistration pendingBuilt 1969 · S/N 28R-35030 N477PCSaint Louis University · Saint Louis, MOBuilt 2019 · S/N 2881200 N477PSSilver Patrick F · Toney, ALBuilt 2016 · S/N 91796 N477RRadtke Jeffrey A · Norwalk, CTBuilt 2003 · S/N 3232006 N477RVVans Aircraft Inc · Aurora, ORBuilt 2004 · S/N 71702 N477SPRegistration Pending · Leesburg, VARegistration pendingBuilt 2004 · S/N 71402 N477TPaetzold Benjamin T · Fort Worth, TXBuilt 1967 · S/N 670274 N477UCWeber Jennifer R · Bryan, TXBuilt 2013 · S/N 001 N477UVUtah Valley University · Orem, UTBuilt 2018 · S/N 4496450 N47808Colgan Aviation LLC · La Crosse, WIBuilt 1979 · S/N 15283253 N4780APenn Flyers LLC · Greensburg, PABuilt 1956 · S/N 22-3931 N4780ECarolinas Aviation LLC · North Myrtle Beach, SCBuilt 1978 · S/N 17271645 N4780JItzchak Arzt · Sarasota, FLBuilt 1967 · S/N MB-228 N4780LLemon Kyle · Santa Ynez, CABuilt 1967 · S/N 28-4115 N4780YPhiladelphia Glider Council · Hilltown, PABuilt 1968 · S/N 25-4548 N47818Fischer Scott R · Spanaway, WABuilt 1977 · S/N 28-7816134 N47819Candace A Larned Enterprises Inc · Long Beach, CABuilt 1977 · S/N 28-7816136

Back to AD 81-18-04 R2