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.

N1442TKeller Mark · Alexandria, KYBuilt 1972 · S/N 28-7205298 N1442UEastern Idaho Flying Club · Idaho Falls, IDBuilt 1976 · S/N 17267109 N1443DEc Aviation Group Corp · Ponte Vedra, FLBuilt 2000 · S/N 1097 N1443RBrown Jesse L · Muscle Shoals, ALBuilt 1975 · S/N AA1B-0543 N1443VSchovanec David L · Stuart, FLBuilt 1974 · S/N 17263580 N14443Mcdonald Gary Lee · Eatonville, WABuilt 2008 · S/N 3005 N1444CFlight Operations Aircraft LLC · Wilmington, DEBuilt 2005 · S/N 172S9890 N1444JShoreys Francis · Northboro, MABuilt 1976 · S/N 444 N1444RRye Steve V · Dickson, TNBuilt 1975 · S/N AA1B-0544 N1444XWaddell Charles · Elk Grove, CABuilt 1975 · S/N 28R-7535283 N1445ESouth Aero LLC · Albuquerque, NMBuilt 1978 · S/N 17271004 N1445TWhelan And Sons Realty LLC · Suffield, CTBuilt 1972 · S/N 28R-7235290 N1446KColeman James P · Sand Springs, OKBuilt 2015 · S/N 8214 N1446XN15956 Inc · Wilmington, DEBuilt 1975 · S/N 28-7525317 N14470Girty Kenneth G · Enid, OKS/N 558 N1447HMarkovich David E · Eden Prairie, MNBuilt 1977 · S/N 28-7725144 N1447JCapital Auto Sales · Hickman, NEBuilt 1976 · S/N 447 N1447TDa Silva Paulo E · Orlando, FLS/N 28R-7235292 N1447XGaventa Edward J · Logan Twp, NJBuilt 1975 · S/N 28-7525318 N1447ZHildebrand Dean A · Mesquite, TXBuilt 2012 · S/N 73178 N1448RWright Roger W · Buckeye, AZBuilt 1975 · S/N AA1B-0548 N1448XMallett Robert T · Wilmington, MABuilt 1975 · S/N 28-7505229 N1448ZNational Training 1 LLC · Wilmington, DEBuilt 2005 · S/N 172S9891 N1449Registered aircraftBuilt 2007 · S/N 7086 N1449CAb Prop Plane I LLC · Metairie, LABuilt 2005 · S/N 172S9892 N1449EChase Matthew S · Rock Hill, SCBuilt 1978 · S/N 17271005 N1449JAlpha Zulu Aviation LLC · Paragould, ARS/N 449 N1449UInternational Aviation Group LLC · Lake Wales, FLBuilt 1976 · S/N 17267116 N1449VLogsdon Timothy D · Livermore, CABuilt 1974 · S/N 17263586 N144AFHelius Aircraft 144af LLC · Conroe, TXBuilt 2007 · S/N 1787 N144AHAtomic Helicopters LLC · Seattle, WABuilt 2001 · S/N 0865 N144AKExpress Helicopters LLC · Houston, TXBuilt 2004 · S/N 10226 N144AMStardust Aviation LLC · Farmingdale, NYBuilt 2021 · S/N 28020016 N144AZBartosh Jason R · Big Pine Key, FLBuilt 1995 · S/N 21911 N144BCThomas George E · Rice, WAS/N 188 N144BFHyldburg Aviation Inc · Plymouth, MABuilt 1974 · S/N 17264101 N144BZCrosswind Leasing LLC · Prescott, AZBuilt 2005 · S/N 10715 N144CCNightingale William T III · Rancho Cucamonga, CABuilt 1975 · S/N AA5B-84 N144CDLittle Gator Aviation Inc · Fairfield, NCBuilt 1999 · S/N 0602 N144CKClover Park Technical College · Lakewood, WABuilt 2026 · S/N 172S13552 N144CLStewart Joseph W II · Eloy, AZBuilt 2006 · S/N 10980 N144CNGalliot Bond LLC · Atlanta, GAS/N 27-8054036 N144CPHobgood Mitch D · Tylertown, MSBuilt 2024 · S/N 20420 N144DFPessel William O Jr · Princeton, NJBuilt 1993 · S/N 1907 N144DHSky 1 Inc · Wilmington, DEBuilt 1996 · S/N 1219-96 N144DJSaybrook Offshore LLC · Guilford, CTBuilt 2017 · S/N 2467 N144DMExecutive Helicopters Inc · Myrtle Beach, SCBuilt 2003 · S/N 10044 N144DNSimmons Donald L · Bonita Springs, FLBuilt 1996 · S/N 2262 N144DRSchneider Robert Keith · Bolivar, TNS/N 23587 N144DSStevenson William E · Sutton, AKBuilt 2000 · S/N 0715

Back to AD 81-18-04 R2