Registered aircraft · 108,433

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:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') 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:2007-04-19-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
  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:2007-04-19-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
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.

N23802Gherst Richard H · Seattle, WABuilt 2000 · S/N 20608137 N23807Crone Patrick · Reston, VABuilt 1999 · S/N 18280468 N2380AAircraft Engineering Inc · Eagle Lake, FLBuilt 1998 · S/N 17280617 N2380CH & M Aviation LLC · Calhoun, GABuilt 1999 · S/N 18280462 N2380MPiggott William H · Madison, CTBuilt 1977 · S/N 28-7890249 N2380PWalker Kody Chance · Hobbs, NMBuilt 1955 · S/N 22-2771 N2380RReep Nicolas K · Yakima, WABuilt 1964 · S/N 18255480 N2380TRegistered aircraftS/N 28-7225060 N2380XGaller Mary D Trustee · Elysian, MNBuilt 1965 · S/N 18256280 N2380YAlbert Jeffrey Frederick · Biltmore Lake, NCBuilt 1999 · S/N 18280465 N2380ZCopeland Medical LLC · Jonesboro, ARBuilt 1979 · S/N 27-8054031 N23816Malloy Dennis John · Mesquite, NVBuilt 1999 · S/N 18280470 N2381CLee Kevin M · Rexburg, IDBuilt 1954 · S/N 30681 N2381FOops LLC · Cheyenne, WYBuilt 1965 · S/N 21058581 N2381GKittelman Thomas L · Gilbert, AZS/N 51681 N2381XCooper Scott J · Fellows, CABuilt 1965 · S/N 18256281 N2381ZLeone Brighter Developments LLC · Carlsbad, CABuilt 2005 · S/N 17281276 N23822Platt James Wesley · Bushnell, FLBuilt 1977 · S/N E-1089 N23824American Lighthouse Transportation Inc · Dry Ridge, KYBuilt 1977 · S/N M-1999 N2382DPerry Donald A · Colleyville, TXBuilt 1999 · S/N 18280471 N2382EGore Group LLC · Eagle Pass, TXBuilt 1999 · S/N 18280472 N2382GGish Joseph B · Lewiston, IDFirst renewal noticeBuilt 1958 · S/N 51682 N2382HWestbank Fishing LLC · Kiln, MSBuilt 1999 · S/N 18280473 N2382LRadloff Nicholas R · Fort Atkinson, IABuilt 1963 · S/N M-222 N2382RTampa Bay Aviation Inc · Clearwater, FLBuilt 1999 · S/N 17280700 N2382TGethers Adolph B · Dothan, ALBuilt 1971 · S/N 28-7205031 N2382XRolleston Moreton M III · Canton, GABuilt 1965 · S/N 18256282 N2382YBarnwater Development Inc · Ardmore, OKBuilt 1998 · S/N 18280380 N23830Klosterman Jack L · Cincinnati, OHBuilt 1978 · S/N M-2002 N2383AAero Traveler Ltd · Warminster, PABuilt 1969 · S/N D-9034 N2383PJkr7 LLC · The Dalles, ORBuilt 1955 · S/N 22-2774 N2383WMcclure Miles · Vancouver, WAS/N MB-18 N2383XComo Aviation LLC · South Weymouth, MABuilt 1965 · S/N 18256283 N2383YAult Stanley K · Cinebar, WABuilt 1965 · S/N 21058583 N23841Lam Capital Management LLC · Sheridan, WYBuilt 1999 · S/N 17280710 N2384GAircraft Holdings LLC · Ellensburg, WABuilt 1958 · S/N 51684 N2384JEdwards Isaac J · Glen Ellyn, ILBuilt 1963 · S/N M-342 N2384LChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 17280706 N2384PLarsen Steve J · Colton, ORS/N 22-2775 N2384QTailwind Ventures LLC · Three Rivers, MIS/N M-464 N2384RMonroe Joel L · Alexandria, MNBuilt 1971 · S/N 28-7110003 N2384SChervenak A Douglas · Smyrna, DEBuilt 1976 · S/N 21061263 N2384UMoody Bible Institute Of Chicago · Spokane, WABuilt 1999 · S/N 17280708 N2384XHill James P · Eagle Point, ORBuilt 1965 · S/N 18256284 N2384YArea-I Flying Club LLC · Atlanta, GAS/N 17700184 N23851Giordano Kim O · Foxboro, MABuilt 1978 · S/N M-2006 N23859Fu Jinlin · Olympia, WABuilt 1976 · S/N MB-811 N2385CSt Charles Flying Service Inc · Portage Des Sioux, MOBuilt 1978 · S/N R18200172 N2385FAlpha Aviation Inc · Mount Vernon, WAS/N 17280714 N2385TSquawk 1200 LLC · Springboro, OHBuilt 1971 · S/N 28-7225064

Back to AD 2007-04-19 R1