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.

N4016ZLong Island Soaring Assoc · Yaphank, NYBuilt 1963 · S/N 18-7966 N4017EJelinek Ed · Denton, MTBuilt 1977 · S/N 18-7809021 N4017FHansen Drew A · Miami Springs, FLBuilt 1976 · S/N 287715002 N4017MBryant Theodore M · Wasilla, AKBuilt 1947 · S/N 12-2895 N4017P17p LLC · Caddo Mills, TXS/N 23-1492 N4017ZB4b Co · Ridgeview, SDBuilt 1963 · S/N 18-7968 N40189Jacob Mark K · East Lansing, MIBuilt 1943 · S/N 51218 N4018EWilliams Matthew S Trustee · Anchorage, AKBuilt 1977 · S/N 18-7809040 N4018MCesare Anthony D · Millinocket, MEBuilt 1947 · S/N 12-2896 N4018TMalfaro William J · Boyertown, PABuilt 1968 · S/N M-1125 N4018ZJarosak Peter J · Valparaiso, INBuilt 1963 · S/N 18-7969 N40193Rearden Logic Inc · Denver, COBuilt 1959 · S/N 24-1239 N4019XBoswell Joey L · Comanche, TXBuilt 1969 · S/N 5119 N4019ZPercy Nolan C · Saint Francisville, LAS/N 18-7971 N401AAAoa Kissimmee Inc · Kissimmee, FLBuilt 2020 · S/N 172S12509 N401ADAlexander Brad K · Melissa, TXS/N 154-74 N401BJJohnson William L · Union City, INS/N 1 N401CDMccartney Terry A · Spirit Lake, IDBuilt 2006 · S/N 1 N401DKBuford Copter Co LLC · Colorado City, TXBuilt 1988 · S/N 0929 N401DSDelaware State University · Dover, DEBuilt 1972 · S/N 34-7250156 N401DTKairos Holdings LLC · Huntsville, ALBuilt 1981 · S/N 17275165 N401EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2020 · S/N 172S12535 N401FLRinaldi Isaac Paul · Richardson, TXBuilt 1971 · S/N 28-7125175 N401GLUlrich Lee · Rio Linda, CABuilt 2014 · S/N 73218 N401HWPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020283 N401HXThree Forks Flying Club Inc · Three Forks, MTFirst renewal noticeBuilt 1974 · S/N 17263490 N401LALee Hunter · Colorado Springs, COBuilt 1965 · S/N 2949 N401LDBrady Kevin J Trustee · Afton, OKBuilt 1977 · S/N AA5B0511 N401LPMustang Sally Aviation LLC · Camden, SCBuilt 2003 · S/N 172S9401 N401LSEl Paso Aero Inc · El Paso, TXBuilt 1982 · S/N 17275784 N401PASkywest Leasing Inc · St George, UTBuilt 2001 · S/N 2843444 N401PJSkylens LLC · Hammond, LABuilt 1968 · S/N 27-4112 N401PKJones Roderick H DBA · Thomasville, GABuilt 1998 · S/N 1438 N401RSawyers Ron S · Hayden, IDBuilt 1991 · S/N 1647 N401RHTofte Shawn A · Lewis Center, OHBuilt 1999 · S/N 1986 N401SHBeta Fleet LLC · South Burlington, VTBuilt 2017 · S/N 1195 N401SWAnderson James Kenneth Jr · Tulsa, OKBuilt 2011 · S/N 18282301 N401TCPrecision Ag Air LLC · Pendleton, INS/N 20279 N401VFSchoenberger Neil J · Saint Petersburg, FLBuilt 2013 · S/N 91486 N401WBNew England Airlines Inc · Westerly, RIBuilt 1969 · S/N 66 N401ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881647 N40200Csc Delaware Trust Co Trustee · Wilmington, DEBuilt 1973 · S/N 27-7304997 N4020DInnovative Design Group Inc · Watkinsville, GABuilt 1999 · S/N 21063C N4020RDemers James D · Firestone, COBuilt 1967 · S/N 3240297 N4020XCox Nathaniel E · Ocala, FLBuilt 1970 · S/N 5149 N4020ZFinch Ernest B · Anchorage, AKBuilt 1963 · S/N 18-7972 N4021Nighthawk N8231g LLC · Pompano Beach, FLBuilt 1979 · S/N 17272149 N4021BElrod Brent W · Cashion, OKBuilt 1975 · S/N 1 N4021HToth Richard C · Tinley Park, ILBuilt 1947 · S/N 12-3448 N4022MBeautte James Edward · Fairland, OKBuilt 1947 · S/N 12-2899

Back to AD 81-18-04 R2