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.

N4695YSnider Scott E DBA · Turner, MTBuilt 1973 · S/N 18-7309019 N46962Soto Del Carpio Nhikitoa · Fairbanks, AKBuilt 1943 · S/N 195 N46964Simsbury Aviation Services LLC · Simsbury, CTBuilt 1979 · S/N 15283152 N4696FTorres Roberto · Bavamon, PRBuilt 1979 · S/N 17273073 N4696JRegistered aircraftBuilt 1968 · S/N 28R-30599 N4696LKoontz Marina M · Seattle, WABuilt 1966 · S/N 17254691 N4696PPolhemus Christopher · Carmichaels, PABuilt 1960 · S/N 27-225 N4696RSchroter Jon A · La Crosse, KSBuilt 1966 · S/N 28-21460 N4696THess Aero Corp Inc · Huntsville, ALBuilt 1981 · S/N R18201737 N4697RHolthaus Cody · Eden Prairie, MNBuilt 1966 · S/N 28-21461 N4697WKellermeyer Steven B · Tucson, AZBuilt 1978 · S/N 13273 N4697ZAntesberger Edward A · Fairfax, VABuilt 1961 · S/N 22-8237 N46983Smale Christopher Cotrustee · Bakersfield, CABuilt 1995 · S/N 54 N4698DDrm Aviation LLC · Glencoe, ALBuilt 1979 · S/N 17272333 N4698FSmith Marciano S · Fort Lauderdale, FLS/N 28-7715061 N4698JShea William Preston · Franklin, TNBuilt 1968 · S/N 28R-30601 N4698MTri-County Sprayers Inc · Hamlin, TXBuilt 1947 · S/N 11-207 N4699JBeach Robert E · Fairfax, VABuilt 1968 · S/N 28R-30602 N4699PGv Air Inc · Medford, ORBuilt 1960 · S/N 27-227 N4699RGillis Jeremiah · Cody, WYBuilt 1966 · S/N 28-21463 N4699SStrike Allen P · Flint, MIBuilt 1969 · S/N 32-1158 N4699YSandhill Soaring Club Inc · Brighton, MIBuilt 1967 · S/N 25-4417 N469AAWings Over Texas Holdings LLC · Denton, TXBuilt 2025 · S/N 344/US N469AKWells Kris G · Barron, WIBuilt 2018 · S/N CC18-0088 N469BJB-29 Enterprises Inc · Canoga Park, CABuilt 1981 · S/N 32-8206017 N469BKClark John Wayne · Lexington Park, MDBuilt 1969 · S/N 32-1156 N469CBCentral Boiler Promotions Inc · Greenbush, MNBuilt 2002 · S/N 1203 N469DLuxury Aviation LLC · Butler, PABuilt 1977 · S/N 32R-7880030 N469DKKimbrough Duke III · Rhome, TXBuilt 1984 · S/N 249 N469DTBarr Air Patrol LLC · Mesquite, TXBuilt 2000 · S/N 18280773 N469EHClaybrook Douglas E · Little Rock, ARBuilt 1978 · S/N R18200335 N469FAStratus Rr LLC · New Castle, DEBuilt 2022 · S/N 28020069 N469FGMustang Sally Aviation LLC · Camden, SCBuilt 2008 · S/N 172S10884 N469FSSunderland Richard · Matthews, NCBuilt 2013 · S/N 73474 N469GWRegistered aircraftBuilt 2010 · S/N 80858 N469JHHolland John R · Jacksonville, FLBuilt 1975 · S/N 645 N469JJTesmer Dean D · Rio, WIBuilt 1989 · S/N 1809030 N469JSToole William B · Goochland, VAFirst renewal noticeBuilt 1966 · S/N MA-23 N469KLM9 Flight LLC · Delhi, LABuilt 1966 · S/N 61 N469MBFloriflt LLC · Daytona Beach, FLBuilt 2005 · S/N 172S9944 N469MHWhat Could Go Wrong LLC · Murfreesboro, TNBuilt 2025 · S/N 18283324 N469NETauber Samara R · La Jolla, CAFirst renewal noticeBuilt 1983 · S/N 17275952 N469RAChorice Kenneth · Bartlett, TNBuilt 1978 · S/N 38-78A0531 N469SMMyres Mark D · Freeland, WABuilt 2021 · S/N KA19290427 N469TCEast Pole Aviation LLC · E Setauket, NYBuilt 2001 · S/N 18280989 N469TFHalf Penny Hangar Inc · Houston, TXBuilt 2022 · S/N 2881592 N469TWEmge Douglas W · Albertville, ALBuilt 1989 · S/N 507 N46AArcher Jimmy R · Houston, TXBuilt 2000 · S/N 002WB N46AARutan Aircraft Flying Experience · Waller, TXBuilt 1981 · S/N 46 N46AHDobbs Joseph D Jr · Charlotte, NCS/N 23180

Back to AD 81-18-04 R2