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.

N169BFBurklund Joel · Minneapolis, MNBuilt 1995 · S/N 1392 N169BRReyna Benjamin M · Bulverde, TXBuilt 2005 · S/N 2019 N169BTAtkison Keith · Centre, ALBuilt 1966 · S/N 28-3776 N169BWFarris Frederick J · Sandpoint, IDBuilt 1978 · S/N 32R-7885080 N169CBGiuffre Vi LLC · Milwaukee, WIBuilt 2002 · S/N 172S9247 N169CCFtt Op!! LLC · Reno, NVBuilt 2006 · S/N CC18-0019 N169CMOsborne Dennis M · East Petersburg, PABuilt 1979 · S/N 32843 N169CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282172 N169CSChavi LLC · Fredericksburg, TXBuilt 2015 · S/N 2407 N169DBFrench David D · Tallahassee, FLBuilt 1969 · S/N 28R-35150 N169DDFlughafen Skyport Ltd · Wilmington, DEBuilt 2001 · S/N 455-2001 N169ETerrell Joe W III · Anchorage, AKBuilt 1966 · S/N 2531 N169ECFirst Eclipse Limited · Richmond, VABuilt 1980 · S/N 172RG0515 N169EZMallory Jessica Lynn · Anchorage, AKBuilt 1976 · S/N 927-76 N169FLBlue Moon Holding Co LLC · Boca Raton, FLS/N 17700047 N169GACut And Snip Flyers LLC · South Weber, UTBuilt 1993 · S/N 2108 N169GSScott Gary L · Kings Beach, CABuilt 2022 · S/N 1165169 N169HCButterfly Wings Of Miami LLC · Miramar, FLBuilt 1973 · S/N 17262693 N169HRStrategic Aircraft Management LLC · Fairbanks, AKBuilt 2004 · S/N 0001 N169JPBoggs Mitchell · La Russell, MOBuilt 1972 · S/N 28R-7235262 N169JRHull Terri L · Weirsdale, FLBuilt 2010 · S/N 24081 N169LHFarmingdale State College · Farmingdale, NYBuilt 2020 · S/N 2881375 N169LPLcc East LLC · Freehold, NJBuilt 1999 · S/N 172S8234 N169MECc Aviation Inc · Tracy, CABuilt 2000 · S/N 172S8449 N169MJPlane Metrics LLC · Fort Worth, TXBuilt 2011 · S/N 80501 N169PXXing Kong Aviation Service LLC · Atwater, CAS/N 17281404 N169RVFoster John O Jr · Hillsboro, ORBuilt 2013 · S/N 90574 N169SHEaa Aviation Foundation Inc · Oshkosh, WIS/N 0169 N169TSkybolt 3 LLC · Arvada, COBuilt 1973 · S/N T-1 N169TRParker Timothy N · Socorro, NMS/N 169 N169TSKestrelx LLC · Lake Mary, FLS/N 1694 N169WHNoble John E · New Kent, VABuilt 2004 · S/N JC10 N169XTalos Aeronautics LLC · Marion, TXBuilt 1993 · S/N 001 N16AHendrix Aviation LLC · Benton, ARBuilt 1978 · S/N R18200405 N16AEKessler Samuel A · Cave Creek, AZBuilt 1984 · S/N 1470 N16AKGriffin Steven M · Enterprise, ALS/N 28R-7918057 N16AMAnimal Health Supply Inc · Vinita, OKBuilt 1968 · S/N 30-1693 N16AUTulsa Air And Space Museum Inc · Tulsa, OKS/N 002 N16BDLambert Thomas E · Roland, IABuilt 1969 · S/N MB-456 N16BJMarshall John Robert · Missouri City, TXBuilt 1979 · S/N 32R-7987115 N16BWSaul Robert D III · Florence, COS/N BW 2-1 N16CBBoecher Carl A · Morrison, COBuilt 2018 · S/N 72745 N16CRHoughton Thomas J · Preston, CTBuilt 1974 · S/N AA5-0679 N16DBDivan Richard W · Wautoma, WIBuilt 1969 · S/N 17258618 N16DLLincoln David · Henderson, NVBuilt 2022 · S/N 1310 N16DMBordonaro Dominic L · Stratford, CTBuilt 1962 · S/N 23-1157 N16DPNdmi Inc · Greeneville, TNS/N 24-3024 N16DVDecathlon LLC · Herndon, VABuilt 2021 · S/N 1193-2021 N16ECSchnell Michael D · New Bremen, OHBuilt 1965 · S/N 28-2683 N16EDSimply Living LLC · Fort Myers, FLBuilt 1985 · S/N 172RG1189

Back to AD 81-18-04 R2