Registered aircraft · 81,728

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.

N309SPSchaumburg Flying Club Nfp · Palatine, ILBuilt 1999 · S/N 172S8245 N309TWest Coast Aircraft LLC · Carson City, NVBuilt 1953 · S/N 18-2423 N309TXCareer Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13230 N309WPMcmahon Peter · Brookfield, CTBuilt 1961 · S/N 24-2955 N30AGAlaskan Outdoors LLC · Soldotna, AKBuilt 1994 · S/N 4131C N30AHMassman Darrel F · Ogdensburg, WIS/N 2407 N30AKRomanski Jack · Berkeley, CABuilt 1996 · S/N 21153 N30AMRoth Douglas D · Lincoln, NEBuilt 1982 · S/N 248 N30BMagill Terry K · Beach City, TXBuilt 1966 · S/N 30-1381 N30BKLoeppky Neal K · Seminole, TXS/N 002 N30BMMoore William E · Franktown, COBuilt 2019 · S/N PT 1090 N30BTKarastamatis Thanassi · Collierville, TNS/N 22-1415 N30CEWren Aircraft LLC · Menlo Park, CABuilt 2003 · S/N 0001 N30CHSale Reported · Maiden, NCSale reported, pending cancellationBuilt 2026 · S/N 4944 N30CSAdams Brad A · Soldotna, AKBuilt 1957 · S/N 18-5409 N30DDRegenstein Jacob · San Francisco, CABuilt 1992 · S/N 20349 N30DSSaver Matthew S · Lebanon, TNBuilt 2003 · S/N 81482 N30DWHeffernan Michael James · Wellesley, MABuilt 1971 · S/N 28R-7135229 N30ECVogt Timothy J · Houston, TXBuilt 1997 · S/N 1284 N30ELGray James C · Jupiter, FLBuilt 2009 · S/N 54 N30ERRance Cory · Moody, TXBuilt 2020 · S/N T-169 N30FATerra Ferma Inc · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1963 · S/N 30-59 N30FCState Alabama Forestry Commission · Florence, ALFirst renewal noticeBuilt 1982 · S/N R18201913 N30FHBaldwin Jonathan B · East Boothbay, MEBuilt 1973 · S/N 34-7350203 N30FKN30fk LLC · Chesterfield, MOBuilt 2012 · S/N 73331 N30FMM20j LLC · Niceville, FLBuilt 1997 · S/N 24-3410 N30GSClausen Robert G · Argyle, MNBuilt 1973 · S/N 17261470 N30GWAnderson Brett J · Groton, SDBuilt 1954 · S/N 18-3939 N30HUDukes William R · Tallulah, LABuilt 1998 · S/N 1406 N30JAJahawk Leasing LLC · Sugar Grove, ILBuilt 1976 · S/N 17268043 N30JBBalbierer John M · Columbus, MSBuilt 1998 · S/N 23892 N30JGAdamson Don · Lonoke, ARBuilt 1976 · S/N 1369 N30JKThompson Troy L · Amarillo, TXS/N 732 N30JNDls Holdings Inc · Lewes, DEBuilt 1957 · S/N 30-1423 N30JPPhilpott Connor J Ryan · Newbury Park, CABuilt 1977 · S/N 1-0052 N30JSFixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 1977 · S/N 28R-7837100 N30JTMatthews William P · Blacksburg, VAS/N 80903 N30JVJasper Aviation Inc · Jasper, ALBuilt 1964 · S/N TD-597 N30JXOptimal Aviation Services LLC · Visalia, CABuilt 1964 · S/N 30-539 N30KWWeeks Kermit A · Polk City, FLBuilt 1974 · S/N 003 N30LERollins Robert · Gadsden, ALBuilt 1971 · S/N 28R-7235018 N30LVNorth Arkansas Aviation LLC · Paragould, ARS/N 28-7916098 N30MEKustudich Tim · Holland, MIBuilt 1985 · S/N MICKELSON-0001 N30NAPerryman Ronald William · Purmela, TXS/N AA1C-0010 N30NKOlah Michael J · Mazomanie, WIBuilt 1984 · S/N 162 N30NWCenterline Aerospace Inc · Clermont, FLFirst renewal noticeBuilt 1964 · S/N 30-312 N30PSweet Kim G · Rogers, ARS/N F8027 N30PCHaas Brent R · Willcox, AZBuilt 2026 · S/N 1492-2026 N30PMReimer Lynn C · Sioux Falls, SDS/N 2 N30PSRosendahl Greg C · Boulder, COS/N K081

Back to AD 81-18-04 R2