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.

N257CHN257ch LLC · Austin, TXBuilt 2008 · S/N 91548 N257CPCivil Air Patrol · Maxwell Afb, ALBuilt 2018 · S/N 172S12133 N257CTLane Community College · Eugene, ORBuilt 1978 · S/N 287816053 N257DCWeaver Lloyd J Jr · Spearfish, SDBuilt 2001 · S/N 2 N257DFHawkins Ian N · Kingwood, TXS/N 117 N257EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2025 · S/N 172S13332 N257FAFly Gateway Aviation Institute · New Castle, DEBuilt 2022 · S/N 28020057 N257FK257fk LLC · Marathon, FLBuilt 1977 · S/N 17269126 N257GIsland Air LLC · Eagan, MNBuilt 2008 · S/N CC18-0031 N257KAWikle Thomas A · Stillwater, OKBuilt 1979 · S/N 38-79A1004 N257MGGeorgia Aviation Authority · Eastman, GABuilt 2021 · S/N 2881450 N257RAReynolds Darryl G · Wills Point, TXFirst renewal noticeBuilt 1975 · S/N 17266240 N257RD4 Flying Z'S LLC · Murfreesboro, TNS/N M-2137 N257RTRoyal Company Sd Inc · Black Hawk, SDS/N 25412 N257SAInternational Air Services Inc Trustee · Carson City, NVBuilt 1969 · S/N 32-40755 N257SDDanmeier Stephen R · Irving, TXS/N 319R N257TRegistration Pending · Pittsfield, MERegistration pendingBuilt 1953 · S/N 18-2371 N257TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881857 N257WDWatts James F · Lone Tree, COBuilt 2022 · S/N 70654 N257ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881612 N25801Vessel Of Honour Ministries · Bluff City, TNBuilt 2010 · S/N 278 N25807Peabody Jeffery L · Vinemont, ALBuilt 1977 · S/N 15280793 N2580BGarcia Edwin · Mckinney, TXBuilt 1978 · S/N 38-79A0131 N2580RFlight Club Academy LLC · Palmetto Bay, FLBuilt 1969 · S/N 28-5650 N2580WLewis Kyle Walker · Trenton, TXBuilt 1965 · S/N 937 N2581Humphreys Kenneth G · Moriarty, NMBuilt 1969 · S/N 1 N2581ASattler Philip J · River Falls, WIBuilt 1952 · S/N 18-2157 N2581FShields Mitchell · Millville, NJBuilt 1965 · S/N 27 N2581MSpencer David W · Anchorage, AKBuilt 1947 · S/N 12-1049 N2581PWick Melvin D · Palmer, AKBuilt 1955 · S/N 18-4323 N2581VMink Stephen Earl · Walnut Creek, CABuilt 1974 · S/N 177RG0625 N2581WClay Shelli V · Savannah, GABuilt 1965 · S/N 938 N25820Sale Reported · Xxx, OKSale reportedBuilt 1977 · S/N 15280799 N2582SHigh Exposure Inc · Wilmington, DEBuilt 1979 · S/N 18-7909161 N2582WPetersen Bennett David · Ashland, OHBuilt 1965 · S/N 3277 N2582ZChandler Air Service Inc · Chandler, AZBuilt 1980 · S/N 27-8154004 N25830Surette Rosemarie · Vail, COBuilt 1980 · S/N 3779 N25836Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15280808 N2583PHudzinski Thomas E · Wasilla, AKBuilt 1955 · S/N 18-4325 N2583WRuckel Daniel A · Floyds Knobs, INBuilt 1965 · S/N 3278 N2584ASorrells David · Gladewater, TXBuilt 1978 · S/N 38-78A0765 N2584PZambarano Matthew · South Hero, VTBuilt 1955 · S/N 18-4326 N2584SStrouckel Jesse · Roscoe, SDS/N 18-7909162 N25852Griffith Aviation Inc · Griffith, INBuilt 1977 · S/N 15280817 N25855Williams Stephen W · Granbury, TXBuilt 1977 · S/N 15280820 N2585ARipplinger Stephen M · Enderlin, NDS/N 18-2161 N2585SWright George E · Homestead, FLS/N 18-7909164 N2585WClassic Mooney Nv LLC · Henderson, NVBuilt 1965 · S/N 940 N25860Sorbi Aviation Inc · El Cajon, CABuilt 1977 · S/N 15280825 N2586AInternational Air Services Inc Trustee · Carson City, NVS/N 38-78A0766

Back to AD 81-18-04 R2