Registered aircraft · 81,720

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.

N15976Lake Life Aviation LLC · Yukon, OKBuilt 1973 · S/N 28-7305203 N15979Tron Aviation LLC · Newburgh, INBuilt 1973 · S/N 28-7310079 N1597BRehman Furqan · Germantown, MDBuilt 1997 · S/N 2843104 N1597HAerobox LLC · Seattle, WABuilt 1975 · S/N 177RG0771 N1597JLs Aviation LLC · Searcy, ARS/N 28-24008 N1597PStokes Letta J · Chugiak, AKBuilt 1954 · S/N 18-3762 N15984Hewitt Jeremy K · West Jordan, UTBuilt 1973 · S/N 28-7325218 N1598AEllis Hal R · Colorado Springs, COBuilt 1952 · S/N 20-836 N1598BTimerider Technologies Inc · Bishop, CABuilt 1982 · S/N 18268108 N1598JHassard Maitland · Goodyear, AZBuilt 1967 · S/N 28-24009 N1598RJam Cat LLC · Orlando, FLBuilt 1975 · S/N AA5B-0098 N15994Self Thomas C · Madisonville, TNS/N 28-7325222 N15997Stockman Greg · Allenton, MIBuilt 1973 · S/N 28-7305210 N15999Emmert Jason L · Douglas, WYBuilt 1973 · S/N 28-7310081 N1599APetro Harold J · Des Moines, IABuilt 1952 · S/N 20-841 N1599RLuka Robert E · Berea, KYBuilt 1967 · S/N 28-3845 N1599XDuffys Aircraft Sales & Leasing Inc · Neillsville, WIBuilt 1975 · S/N 28-7505245 N159ARRobertson Duncan · ForfarNon-citizen corporation, flight hours not reportedBuilt 2007 · S/N 47013T N159AWLutz Robert J · Mount Victory, OHBuilt 1978 · S/N 18-7809035 N159BBBrown Brian R · San Diego, CABuilt 2017 · S/N 159 N159CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281859 N159DBJohnson Justin T · Wasilla, AKBuilt 2019 · S/N 001 N159DRPiedmont Flight Inc · Winston Salem, NCBuilt 1998 · S/N 18280128 N159DSSmart Charles R · Verden, OKBuilt 1978 · S/N 70384 N159DWWilcoxon Duane E · Arlington, WAS/N PITTS 01 DW N159ERTetterton Marshall O · Crescent City, FLBuilt 1989 · S/N 2841211 N159FCDept Of Agriculture & Consumer Services · Tallahassee, FLBuilt 2008 · S/N 18282065 N159FSEastern Kentrucky University · Richmond, KYBuilt 1999 · S/N 17280816 N159KIsland Hopper Air LLC · Ponte Vedra Beach, FLBuilt 1959 · S/N 751 N159LBBender Lyle D · Lincoln, NEBuilt 2009 · S/N 40403 N159MHPw Air LLC · Rockingham, VABuilt 2001 · S/N 1135 N159NDSkyborne Airline Academy Inc · Vero Beach, FLBuilt 1998 · S/N 2842031 N159RJBas Part Sales LLC · Greeley, COBuilt 1973 · S/N 17702038 N159RPHeadings Norman D · Walnut, ILBuilt 1997 · S/N 0342 N159RRRatliff Randall L · Glencoe, OKBuilt 2018 · S/N 41712 N159RSTechnical Education Services Inc · Virginia Beach, VAS/N 27-2817 N159RVTullos George E · Madison, MSFirst renewal noticeBuilt 2003 · S/N 90362 N159SBBdl Properties LLC · Kalispell, MTBuilt 2010 · S/N 72823 N159SHSpitzer Helicopter LLC · Woodland Hills, CABuilt 2007 · S/N 4171 N159SKSeacrest Enterprises LLC · Asheville, NCBuilt 1979 · S/N A1520900 N159TGumley Titus G · Wasilla, AKBuilt 1953 · S/N 18-2273 N159TCShooting Star Museum · Devine, TXBuilt 1977 · S/N 15280724 N159TMKcsi Aerial Patrol Inc · Bakersfield, CABuilt 2002 · S/N 462-2002 N159UUtah State University · Logan, UTBuilt 2025 · S/N 40.1255 N159WMFixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 2002 · S/N 4496159 N15ADDurrent Aviation LLC · Anchorage, AKBuilt 1978 · S/N 18-7809065 N15AFRogers Jeff · Harrogate, TNBuilt 1976 · S/N 17267237 N15AGOber John A · Candor, NYBuilt 1966 · S/N 349 N15AMWhalen John M III · Boise, IDBuilt 1976 · S/N 691173 N15ANAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13258

Back to AD 81-18-04 R2