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.

N1575HCardinal Shares Inc · Rochester, MNS/N 177RG0749 N1575KSnodderly Jean · Ward Cove, AKBuilt 1946 · S/N 4302 N1575RSpurlock Daniel C · Harrogate, TNS/N AA5B-0075 N1575VMissouri Reliability Services LLC · Maryville, MOBuilt 1974 · S/N 17263675 N15760Been Flyin LLC · Colchester, CTBuilt 1972 · S/N 28-7325157 N15762Carlevaro Bruce C · Edmond, OKBuilt 1972 · S/N 28-7305140 N15763First Pryority Bank · Pryor, OKBuilt 1972 · S/N 28-7305141 N15764Leyva Jose Luis · New Smyrna Beach, FLBuilt 1972 · S/N 28R-7335089 N15765Moulder Tyler Dane · Huntsville, ALBuilt 1972 · S/N 28R-7335090 N15768Khleb Hub LLC · Palm Coast, FLBuilt 1973 · S/N 28-7325156 N1576AHile Adam V · Apple Creek, OHBuilt 1951 · S/N 20-790 N1576JInspire Aviation LLC · Magnolia, TXBuilt 1967 · S/N 28-23982 N15770Collett Palmer · Frankfort, KYBuilt 1972 · S/N 28-7325159 N1577AYoung Carl J · Lubbock, TXBuilt 1951 · S/N 20-812 N1577ESeibert Lynn K · Fresno, CAS/N 1131 N1577PPaulson Dean S · Eagle River, AKBuilt 1954 · S/N 18-3740 N1577RGlobal Aircraft Trust Inc Trustee · Cheyenne, WYBuilt 1981 · S/N 278154026 N15782Crane Austin · Redlands, CAS/N 28-7305144 N15783Pretorius Anthony · Easley, SCBuilt 1972 · S/N 28-7305145 N15788Chafin Gerald III · Mountain Home, ARS/N 32-7300016 N15789Sidc2 LLC · North East, MDBuilt 1973 · S/N 34-7350094 N1578HKramer Jason K · Longview, TXBuilt 1975 · S/N 177RG0752 N1578SLamberson Jeremy A · Placerville, CAS/N S9611 0201 N1579ADelap Jay · Collinsville, OKBuilt 1951 · S/N 20-813 N1579JTornow Saxon Michael · Highland, UTS/N 28-23987 N1579RSkelton James P Jr · Lithia Springs, GABuilt 1975 · S/N AA5B-0079 N1579TPedro Christopher M · Dushore, PABuilt 1997 · S/N 5055 N1579XBuchberger Robert J · Plainfield, WIBuilt 1975 · S/N 28-7510111 N157AMPhotofax Inc · Gilberts, ILFirst renewal noticeBuilt 2001 · S/N 2157 N157ARPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010053 N157BBPtc Flyers LLC · Peachtree City, GABuilt 2014 · S/N 72004 N157CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281857 N157CTCentral Texas College Aviation Science Dept · Killeen, TXBuilt 2024 · S/N 1037 N157DF157df LLC · Madison, WIS/N 17260646 N157DLSweet David L · Clovis, CABuilt 2010 · S/N 21079 N157FCDepartment Of Agriculture & Consummer Services · Tallahassee, FLBuilt 2006 · S/N 18281875 N157GSRegistered aircraftBuilt 1997 · S/N 20480 N157GWFoster Colt D · Eagle River, AKBuilt 1957 · S/N 18-6182 N157HSFairbairn Travis J · Fort Worth, TXS/N 40634 N157JPParle John T · Thor, IABuilt 2000 · S/N 224 N157KCNorthwestern Michigan College · Traverse City, MIBuilt 2010 · S/N 172S11037 N157LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842199 N157MAMaronick Richard · East Helena, MTBuilt 2012 · S/N 3167 N157MEMaine Coastal Flight Center Inc · Bangor, MEBuilt 2000 · S/N 172S8436 N157NHRegistered aircraftBuilt 1981 · S/N 15285106 N157PJCarnighan Kelly · New Albany, INBuilt 1946 · S/N 12-1152 N157RDBoman & Kemp Lc · Ogden, UTBuilt 1999 · S/N 18280646 N157RFAir Direct Holdings LLC · Stow, MABuilt 1967 · S/N 108 N157RJTdt Ag Support LLC · Brawley, CABuilt 1979 · S/N 28-7911168 N157RVJohnson Rian L · Portland, ORBuilt 2003 · S/N 70000

Back to AD 81-18-04 R2