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.

N2566QCarothers Rayburn T · Brevard, NCBuilt 1977 · S/N 28-7725201 N2566UHighland Aero LLC · Mcminnville, TNBuilt 1980 · S/N 28-8090059 N25671Westphal Martin W · Cecil, WIBuilt 1981 · S/N 38-81A0045 N2567LGolden Valley LLC · Missoula, MTS/N 18-8109014 N2567WSullivan Eric V · Santa Barbara, CABuilt 1965 · S/N 3271 N2568DPritchett Gregory L · Ozark, ALBuilt 2002 · S/N 5261 N2568JState Of Utah · Salt Lake City, UTBuilt 1979 · S/N 18-7909131 N2568QCasey William · Celina, TXBuilt 1977 · S/N 28-7716113 N2568RCraven James J · Pensacola, FLBuilt 1969 · S/N 28-5649 N2568TDeuel Justin R · Mankato, MNS/N 23779 N2568WSale Reported · Modesto, CASale reportedBuilt 1965 · S/N 3272 N2569AChalmers Aviation LLC · Hyrum, UTS/N 22-871 N2569COswalt Nicholas J · Caro, MIS/N 38-79A0232 N2569FStuart Philip · Tallahassee, FLBuilt 1966 · S/N 400 N2569MSp Airparts LLC · Moscow, IDBuilt 1946 · S/N 12-940 N2569QWatch Ya Head Aviation I LLC · West Haven, UTBuilt 1977 · S/N 28-7790407 N2569WDenenny Richard H · Spokane Valley, WABuilt 1965 · S/N 930 N256AAAlf Ix LLC · Chicago, ILBuilt 2019 · S/N 4496476 N256ACAtwood Jerry L · Sweet Home, ORBuilt 1956 · S/N 22-3788 N256AMEdwards Bruce D · Georgiana, ALBuilt 2003 · S/N 2256 N256ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496067 N256BSlayton Michael B · Grand Haven, MIBuilt 1957 · S/N 16 N256BLBasic Airplane Society Inc · Delphi, INBuilt 1990 · S/N 121 N256CBFesak Matthew L · Fuquay Varina, NCBuilt 1998 · S/N 5427 N256DNau Howard A · Melba, IDBuilt 1947 · S/N 12-2903 N256DMBailey Joseph H · Port Saint Lucie, FLBuilt 1978 · S/N 32R-7885028 N256EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2025 · S/N 172S13317 N256FFiggins David B · Tulsa, OKBuilt 2008 · S/N 001 N256FAFly Gateway Aviation Institute · New Castle, DEBuilt 2022 · S/N 28020056 N256GDAugust Aero LLC · Kalispell, MTBuilt 2003 · S/N 23639 N256GPAts One LLC · Mountain View, CABuilt 2002 · S/N 172S9256 N256JD Gordon Aviation Inc · La Jolla, CABuilt 1978 · S/N ME-107 N256KALarson Home Builders LLC · Klamath Falls, ORBuilt 1978 · S/N 38-78A0759 N256MGGeorgia Aviation Authority · Eastman, GABuilt 2021 · S/N 2881447 N256MMHigh Key Management LLC · Boerne, TXBuilt 2016 · S/N 80688 N256MWLease Air LLC · Moab, UTBuilt 1977 · S/N 17269958 N256PCHall Robert · Rapid City, SDBuilt 1969 · S/N 18 8537 N256RVKnapp Peter · Kinderhook, NYBuilt 2008 · S/N 20810 N256SAAirview Inc · Ligonier, PABuilt 1983 · S/N R18201967 N256SCNovember Alpha LLC · Dover, DEBuilt 2006 · S/N 4007 N256SFAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 172S13403 N256SMMccartney Steven R · Camarillo, CABuilt 2020 · S/N 23589 N256TPulkrabek David P · Hutchinson, MNBuilt 1953 · S/N 18-2370 N256ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881611 N2570ASlaughter Don Wayne · Farmville, NCBuilt 1952 · S/N 20-937 N2570MBills Nathan · Overland Park, KSS/N 12-921 N2570PStaneli Lee A · Kiana, AKBuilt 1956 · S/N 18-4310 N2570UJla Aero LLC · State College, PABuilt 1979 · S/N 28-8016036 N2571APeterson Ronald A · Campbell, TXBuilt 1952 · S/N 20-939 N2571EStrojny Andrew P Jr · Strongsville, OHBuilt 1978 · S/N 38-78A0578

Back to AD 81-18-04 R2