Registered aircraft · 5,075

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:84-19-03-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:84-19-03-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:84-19-03-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:84-19-03-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:84-19-03-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:84-19-03-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.

N225ZMoe Kevin · West Chester, OHBuilt 2001 · S/N 20040 N2265QMyl High Flying Club LLC · Mccall, IDS/N 32-7740048 N2268BNitro Aviation LLC · Englewood, COBuilt 2005 · S/N T20608574 N2269MSpencer Donald I Jr · Knoxville, TNBuilt 1977 · S/N 32R-7880060 N226BVKimberlin G Tyler · Fairbury, NEBuilt 1976 · S/N 32R-7680225 N226MELawson Tim · San Clemente, CABuilt 2000 · S/N T20608191 N227AKHanzawa George K · Wahiawa, HIBuilt 1981 · S/N 31-8152198 N227ECEcjet Inc · Downey, CABuilt 1974 · S/N 31-7405184 N227EMVisceral Technologies LLC · Yulee, FLBuilt 2001 · S/N 3257208 N227RGLearn To Fly In Central Arkansas LLC · Searcy, ARBuilt 1974 · S/N 27-7554021 N227RMHeli Coral Inc · Wilmington, DEBuilt 1979 · S/N 31-7912085 N227WDPowell David C · Ingram, TXBuilt 1990 · S/N 4622097 N227WFTrayler James · Waco, TXBuilt 2004 · S/N T18208288 N2288QMidnight 30 LLC · Columbia, MSBuilt 1977 · S/N 32R-7780242 N228CABowles Thomas J · Prairie Village, KSBuilt 1981 · S/N R18201686 N228CMKittleson Allen F · Granbury, TXBuilt 1973 · S/N 73-31058 N228GHopkins Boone K · Saint Simons Is, GAS/N 612 N228HSSweeney David H · Houston, TXBuilt 2003 · S/N T20608419 N228JPMazel Wings LLC · Camden, DEBuilt 2000 · S/N 18280711 N22952Winging It LLC · Lindon, UTBuilt 2007 · S/N T18208740 N2296QKhawly Pablo Nickolai · Miramar, FLBuilt 1977 · S/N 32R-7780244 N2297MHunter Stokes & Associates LLC · Douglasville, GABuilt 1977 · S/N 32R-7880061 N2297QFact Ware Inc · Newtown, PABuilt 1977 · S/N 32R-7780245 N2298MLeft Seat Flyers LLC · Mount Pleasant, SCBuilt 1977 · S/N 32R-7880062 N229MKyzer Aviation Holdings LLC · Fort Mill, SCBuilt 1969 · S/N 27-4252 N229MAN&D Executive Services LLC · San Antonio, TXS/N 4636129 N22CHSupergo LLC · Menlo Park, CABuilt 1999 · S/N T20608101 N22CKAdams Ventures LLC · Lowell, ARBuilt 1982 · S/N 32R-8213048 N22DTMartin Communications Inc · West Monroe, LABuilt 1975 · S/N 32-7640033 N22HMPetrzelka Ivan · Red Bluff, CABuilt 1990 · S/N 27-0037 N22NLD2k Aviation LLC · Boyden, IABuilt 1987 · S/N 32R8629006 N22SYSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1997 · S/N 4636122 N22TKGreen Theodore G · Franklin, WIBuilt 1963 · S/N 24-3541 N22VTMcmath Robert Roy · Seeley Lake, MTBuilt 1977 · S/N 27-7754074 N2301QFarm West LLC · Missoula, MTBuilt 2001 · S/N T20608263 N230ASN230as LLC · Wilmington, DEBuilt 1980 · S/N 31-8012062 N23138Donaldson Docks Inc · Estherville, IAS/N 32R-8529010 N232CASawdust Aviation Inc · Bellefonte, PABuilt 1976 · S/N 32-7740026 N232TJCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N T20608556 N232TSTwo Tango Sierra LLC · Edmond, OKBuilt 1982 · S/N 32R-8229041 N232YPGill Joshua Daniel · Tucson, AZS/N 24-3401 N234BLSullivan Leo W · O Fallon, ILBuilt 1997 · S/N 27-0234 N234CEAir Arctic Inc · Fairbanks, AKBuilt 1980 · S/N 31-8052203 N234DLAngel Wings LLC · Waxhaw, NCFirst renewal noticeBuilt 1983 · S/N 32R-8329029 N234JFInternational Air Services Inc Trustee · Carson City, NVS/N 32R-7887265 N234MFGone Flying LLC · Salt Lake City, UTBuilt 2006 · S/N T18208492 N2365FBottorff Jon C · Fishers, INBuilt 1999 · S/N T20608102 N2365JBrosius Michael W · North Platte, NEBuilt 1999 · S/N T20608099 N2369WRoyal Kenneth L · Savannah, GABuilt 1985 · S/N 32R-8529014 N236CMWright Kim B · Anchorage, AKBuilt 1997 · S/N 27-0236

Back to AD 84-19-03 R1