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.

N4943LBonus Kurt · Wind Lake, WIBuilt 1980 · S/N 15284245 N4943ZBlackford Robert G · Mt Airy, MDBuilt 1961 · S/N 22-8538 N49447Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15281274 N4944LWilson Zane D · Fairbanks, AKBuilt 1967 · S/N 28-4313 N4944SEmbry Riddle Aeronautical University · Prescott, AZBuilt 1980 · S/N R18201483 N4944VDavies William T · Auburn, WABuilt 1955 · S/N 1 N4944ZHoppes Larry J · Springville, INBuilt 1961 · S/N 22-8540 N49455Above All Aviation Inc · Goleta, CABuilt 1978 · S/N 15281281 N4945FEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 2002 · S/N 10015 N4945JAsher Academy · Cameron, TXS/N 28R-30692 N4945LAlahmadi Hussein I · Avon, CTS/N 28-4314 N4945WBlueline Flight Systems LLC · Orlando, FLBuilt 1977 · S/N 14267 N4945ZWillis James · Pelham, ALBuilt 1961 · S/N 22-8541 N49461Blue Sky Aviation LLC · Watkins, COBuilt 1978 · S/N 15281287 N4946LAndrews University · Berrien Springs, MIBuilt 1967 · S/N 28-4315 N4946TElite Fleet Jacksonville LLC · Jacksonville, FLS/N 28-7225286 N49471Aeroquest LLC DBA · Olive Branch, MSBuilt 1978 · S/N 15281294 N4947GRiya Aviation LLC · Tracy, CABuilt 1980 · S/N 17273494 N4947JElite Fleet LLC · Spofford, NHBuilt 1968 · S/N 28R-30694 N4947LAmoth Dallas V · Bonners Ferry, IDBuilt 1967 · S/N 28-4316 N4947SZams Aviation LLC · Raleigh, NCBuilt 1980 · S/N R18201486 N4947WBloom Kevin Lynn · Freeport, FLBuilt 1977 · S/N 14269 N4947ZSatreaas Kenneth A · Verona, NDBuilt 1961 · S/N 22-8543 N4948Andersen Bret E · Chugiak, AKBuilt 1969 · S/N 18-8745 N4948GTrece Inc · Adair, OKS/N 17273495 N4948STaildragon LLC · Albuquerque, NMBuilt 1980 · S/N R18201487 N4948ZSenn Joshua · Depauw, INBuilt 1961 · S/N 22-8545 N4949GFalcon Aviation LLC · South Saint Paul, MNBuilt 1979 · S/N 17273496 N4949LLim Young Keun · Carthage, MOBuilt 1967 · S/N 28-4318 N4949MCorben Sport Planes Museum LLC · Toccoa, GAS/N 20-640 N4949PSonn Jeffrey R · Descanso, CAS/N 27-545 N4949ZPeeples Ryan · Folkston, GABuilt 1961 · S/N 22-8546 N494ABGluff Alan D · Franklin, INBuilt 2012 · S/N 91692 N494AMOsprey Holding Company LLC · Foley, ALBuilt 1978 · S/N 17269969 N494CMLeadership In Training Education Inc DBA · Apollo Beach, FLBuilt 2000 · S/N 001 N494DSBeulah Ltd Trustee · Wilmington, DEBuilt 2003 · S/N 40.294 N494DWVieira Mark T · Turlock, CABuilt 2009 · S/N 001 N494EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2015 · S/N 172S11602 N494FLWilliams Mark J · Ojai, CABuilt 1971 · S/N 28-7125309 N494HSale Reported · West Palm Beach, FLSale reported, pending cancellationBuilt 1975 · S/N 309 N494JBD & S Aviation LLC · Spring, TXBuilt 2002 · S/N 172S9099 N494JGGallagher Joseph Leo · Reno, NVBuilt 2017 · S/N 72712 N494LAPiper 3 LLC · Chestnut Ridge, NYBuilt 2021 · S/N 28020022 N494LWWitte Steven E · Egan, SDBuilt 2011 · S/N 40667 N494RVBerthold Myles A · Belleville, ILBuilt 2006 · S/N 0002 N494SHIhde Investments Lp · Red Oak, TXBuilt 2005 · S/N 10878 N494SPInternational Air Services Inc Trustee · Carson City, NVBuilt 1998 · S/N 172S8035 N494TMDuke Flight Training LLC · Bonnyman, KYBuilt 1975 · S/N 17265022 N494WAFly More Inc · Kawkawlin, MIBuilt 1978 · S/N 17271129 N4950AShaffer Barbara J · Franklin, KYS/N A1520910

Back to AD 81-18-04 R2