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.

N1673California Flight Museum · Coronado, CAS/N P-10 N1673ASheeley Patrick D · High Falls, NYBuilt 1952 · S/N 22-436 N1673CCe-172 Aircraft LLC · Wilmington, DEBuilt 2012 · S/N 172S11761 N1673EHusband Thomas W · Bigfork, MTBuilt 1978 · S/N 17271090 N1673GLake Robert F · Mechanicsville, MDBuilt 1968 · S/N 644 N1673HTronerud Jason · Maple Grove, MNBuilt 1977 · S/N 32-7740037 N1673JSouthern Colorado Flight Professionals LLC · Pueblo, COBuilt 1967 · S/N 28-24074 N1673RGregory John F · Emmitsburg, MDBuilt 1978 · S/N R18200508 N1674EMedary Aviation LLC · Brookings, SDBuilt 2005 · S/N 172S9915 N1674JCaloon John H · Greenfield, MABuilt 1968 · S/N 28-24075 N1674VAbraham Elizabeth J · Browntown, WIBuilt 1974 · S/N 17263709 N1675GKraft Jesse · Twain Harte, CAS/N 130 N1675HIcarus Flying Academy LLC · Farmingdale, NYBuilt 1977 · S/N 28-7716040 N1675JTevis Aviation Inc · Emporia, KSBuilt 1967 · S/N 28-24076 N1676CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11762 N1676GCain Landa B · San Diego, CAS/N 131 N1676RBlue Side Up LLC · Elbert, COBuilt 1978 · S/N R18200510 N1677JCross X Country LLC · Great Falls, VABuilt 1968 · S/N 28-24078 N16789Smith Stephen · Annandale, VABuilt 2005 · S/N 172S9916 N1678CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11763 N1678HBrown Gregory B · New London, CTBuilt 1977 · S/N 28-7790330 N1678JCloudhoppers Inc · Effingham, ILBuilt 1967 · S/N 28-24079 N1679ARostron Christopher M · Kokomo, INS/N 22-441 N1679PClearwater Potlatch Timber Pa · Orofino, IDBuilt 1954 · S/N 18-4068 N167BHHolliday Robert R · Andover, KSBuilt 1966 · S/N 17255345 N167BWMartin Jennifer · Palm Desert, CABuilt 1974 · S/N 12475 N167CJMunn Oliver L · Ocala, FLBuilt 2010 · S/N 25879 N167CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 172S12500 N167CSBalister Adrian G · Colorado Springs, COS/N 23197 N167CWNorinsky David · Petaluma, CABuilt 2002 · S/N 1001 N167GTPreferred Procurement LLC · Sheridan, WYBuilt 2001 · S/N 2007 N167JMMiller James D · Wilmington, NCBuilt 2017 · S/N 071 N167LDRegistered aircraftS/N 670105 N167LPSymanowski Kevin L · Reeder, NDBuilt 2001 · S/N 18281067 N167MSMullinax Robert A · Toccoa, GABuilt 1993 · S/N 2105 N167PCBlue Mountain Flyers Inc · Palmerton, PABuilt 2003 · S/N 1349-2003 N167QHanson John W · Stewartville, MNBuilt 2009 · S/N HC012 N167QQGrondahl Chad R · Peyton, COBuilt 1966 · S/N 670149 N167RMSellman Richard · Chadron, NEBuilt 1967 · S/N 18-8514 N167RVWelch Jason · Concrete, WABuilt 2016 · S/N 001 N167SDierenfeldt William Travis · Manhattan, KSS/N MC-18 N167SUSouthern Utah University · Cedar City, UTBuilt 2020 · S/N 30064 N167TCFarzaneh-Far Ramin · Brookline, MABuilt 2001 · S/N 1304-2000 N167UDLima 001 LLC · Muscatine, IABuilt 2003 · S/N 17281188 N1680APaprocki Jason C · Fairplay, COS/N 20-842 N1680GSears Richard A · Stevensville, MDBuilt 1968 · S/N 135 N1680RSchulze Roger F · Hanford, CABuilt 1978 · S/N R18200512 N1681PWarner Philip · San Marcos, CABuilt 1954 · S/N 22-2467 N1682AMackie Scott B · Woodstock, GABuilt 1952 · S/N 20848 N1682JBeatty Gary A · Mosinee, WIFirst renewal noticeBuilt 1967 · S/N 28-24083

Back to AD 81-18-04 R2