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.

N2388ZKoehler Brian L · Washington, IAS/N M-94 N2389DRowland James E Jr · Pennsville, NJFirst renewal noticeBuilt 1978 · S/N 38-79A0293 N2389FDavenport Jimmy J · Hayesville, NCBuilt 1978 · S/N 38-79A0413 N2389SPhillips Aviation Enterprises Inc · Petoskey, MIBuilt 1979 · S/N R18201335 N2389TForeman O Dean · Springfield, TNBuilt 1978 · S/N 38-78A0789 N2389VMoody Bible Institute Of Chicago · Spokane, WABuilt 1999 · S/N 17280729 N2389WCherney Cody L · Belleville, KSBuilt 1966 · S/N MB-24 N238ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496037 N238CPCivil Air Patrol · Maxwell Afb, ALBuilt 2017 · S/N 18283016 N238DSilver Creek Aviation Services · Fort Worth, TXBuilt 2005 · S/N 20608238 N238DMCopeland Gary L · Williamsburg, MIBuilt 1972 · S/N 19-72 N238FYSpace Coast Aircraft Inc · Merritt Island, FLBuilt 1989 · S/N 2841175 N238GMac-V Aviation Inc · Central Point, ORBuilt 2007 · S/N 196C N238LSMckissock Mark D · Cambridge Springs, PABuilt 2011 · S/N 91019 N238MAFogg Phillip G · Aurora, ORBuilt 1998 · S/N 5238 N238MCBrotherton Douglas E Trustee · Dubuque, IABuilt 1993 · S/N 3213047 N238MGGeorgia Aviation Authority · Eastman, GABuilt 2024 · S/N 2881816 N238MJRivard Matthew G · Kansas City, MOBuilt 2025 · S/N 42596 N238NDPlane Nonsense · Middletown, DEBuilt 2000 · S/N 2842101 N238RTTorres Ramon A · Mulberry, FLBuilt 1972 · S/N 506 N238RVRegistered aircraftS/N 23880 N238SPEdb Air Inc · Wilsonville, ORBuilt 1999 · S/N 172S8223 N238SSAppling Aviation LLC · Baxley, GABuilt 2020 · S/N JA 559-7-19 N238THoffer William T · Orr, MNBuilt 1953 · S/N 18-2352 N238TCTexas State Technical College · Waco, TXBuilt 2025 · S/N 28020238 N238THLewis University · Romeoville, ILBuilt 2018 · S/N 172S12140 N238TWDunlap Allan D · Spokane, WABuilt 1981 · S/N 17275287 N238UTecnam US Inc · Sebring, FLBuilt 2023 · S/N 238/US N238WMMchatton Dret A · Redding, CABuilt 1967 · S/N 28-10924 N2390AAgnew Michael D · Pardeeville, WIS/N 22-756 N2390CIasco Flight Training Inc · Redding, CABuilt 1999 · S/N 17280789 N2390HBrott Brian A · Kasilof, AKBuilt 1979 · S/N 18-7909176 N2390LTsiouklas Anthony P · Dunedin, FLBuilt 1963 · S/N M-235 N2390PLubben Thomas H · Madison, WIBuilt 1955 · S/N 22-2781 N2390QLatia Douglas C · Lafayette, INS/N M-471 N2390TKessler Derek D · Lexington, OKS/N 28-7225068 N2390WNgk Aviation LLC · West Point, NEBuilt 1966 · S/N MB-28 N2390ZTicen Jeffrey L · Chalmers, INBuilt 1962 · S/N M-113 N23917Hill Judith L · Carriere, MSBuilt 2012 · S/N DR1-23917-1956 N2391GSeay Bradley Andrew · Vienna, VABuilt 1999 · S/N 18280536 N2391MClover Park Technical College · Lakewood, WABuilt 2003 · S/N 17281171 N2391POberholtzer Robert H · Streator, ILBuilt 1955 · S/N 22-2782 N2391QNew Hamphire Flyers LLC · Lyme, NHBuilt 1977 · S/N 28-7790395 N2391TLotnicza LLC · Houston, TXBuilt 1971 · S/N 28-7225069 N2391UJeffway Robert W Jr · Leeds, MABuilt 1979 · S/N 32-7940253 N2391WShanahan Jolene D · Upper Lake, CAS/N MB-29 N2391YOleksyn Anthony · Fairport, NYBuilt 1967 · S/N 17700191 N2392BMorton Dennis D · La Harpe, ILBuilt 1999 · S/N 001 N2392HPeterson John A · Anchorage, AKBuilt 1979 · S/N 18-7909170 N2392LLindell Tom R · Cashmere, WAFirst renewal noticeBuilt 1963 · S/N M-237

Back to AD 81-18-04 R2