Registered aircraft · 10,536

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:2004-25-16-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:2004-25-16-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:2004-25-16-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:2004-25-16-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:2004-25-16-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:2004-25-16-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.

N1335PRiggin Flight Service Inc · Madison, SDS/N 23-380 N133CTValiair Lc Trustee · Casper, WYBuilt 1979 · S/N 31-7912118 N133MRPrecision Aero LLC · Wilmington, DEBuilt 1978 · S/N TC-2173 N133NDHitch-Nel Partners LLC · Issaquah, WABuilt 1975 · S/N 33701669 N133PCGilco Distributors · Santa Rosa, CABuilt 1976 · S/N 340A0093 N1344PCrist Charles E · Waxahachie, TXBuilt 1955 · S/N 23-390 N134ACSkyline Solutions Inc · Deland, FLBuilt 1972 · S/N 34-7350014 N134DSDoge Aircraft LLC · Boca Raton, FLBuilt 1982 · S/N 348233148 N134DWAtp Aircraft 1 LLC · Wilmington, DES/N 4496167 N134FLift Enterprises LLC · Lynn Haven, FLBuilt 1964 · S/N TC-816 N134FSAlcione LLC · Miami, FLBuilt 1978 · S/N 27-7854117 N134GGGibson Gordon S Trustee · Pacific Palisades, CABuilt 1981 · S/N 340A1202 N134MDAa Aviation LLC · Lewes, DES/N TJ-449 N134MGCsa Aircraft Leasing LLC · Salt Lake City, UTBuilt 1981 · S/N 34-8233007 N134MLL3 Cts Airline Academy · Sanford, FLBuilt 2019 · S/N 4496483 N134MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2024 · S/N 4496593 N1350SLo Pilato Family Flights Inc · Coral Gables, FLBuilt 1976 · S/N TH868 N1352PHouse Travis · Bristow, VABuilt 1955 · S/N 23-401 N135FBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1977 · S/N TH816 N135MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2024 · S/N 4496594 N135PBD&R Holdings LLC · Kailua, HIS/N 31-7952035 N135RWOneal Eric T · Geneva, FLBuilt 1981 · S/N TJ-351 N135TWValiair Lc Trustee · Casper, WYS/N 31-7852001 N135UInter American University Of Puerto Rico · Bayamon, PRBuilt 1997 · S/N 4496015 N1360LKoukol Orin Trustee · Sacramento, CABuilt 1978 · S/N 33701852 N1362CPaw Management Inc · Calimesa, CAS/N 340A0012 N1365LKropp Christian Trustee · Azle, TXS/N 33701857 N1367PBuzzard Air Service LLC · Carleton, MIBuilt 1956 · S/N 23-416 N1369TWings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 34-7250301 N136DWSun Aircraft Management LLC · Ormond Beach, FLBuilt 2003 · S/N 4496168 N137Bigfoot Aviation LLC · Saint Michael, MNBuilt 1960 · S/N 310-0028 N13760Chiniewicz Michael · The Colony, TXBuilt 1969 · S/N 27-4409 N1379GTwo Golf Tango LLC · Albuquerque, NMBuilt 1976 · S/N 340A0078 N137ASFlight Leasing Corp · Wilmington, DES/N ME-72 N137JHFlatspin LLC · Belle Chasse, LABuilt 1981 · S/N 31-8252025 N137JPRitec LLC · Sandown, NHBuilt 1982 · S/N TH-1322 N137MCPoland Gilbert Guardian · Dothan, ALBuilt 1965 · S/N 337-0127 N13803Crociati Douglas R · Plymouth, MABuilt 1969 · S/N 27-4448 N1380GWalborn & Associates Inc · Mountain Home, IDBuilt 1976 · S/N 340A0079 N1380TN1380t LLC · Wilmington, DEBuilt 1972 · S/N 34-7250302 N13817Conroy Philip L DBA · Colleyville, TXBuilt 1969 · S/N 27-4462 N1381PObermueller Frederick J · Milford, NJBuilt 1956 · S/N 23-431 N13832Davey Spencer J · Spokane, WAS/N 27-4474 N13839Tyler Petroleum Inc · Tyler, TXBuilt 1970 · S/N 27-4480 N1383GKuper Carl J II · Dalhart, TXBuilt 1976 · S/N 340A0082 N1384PHanson Roddy L · Butterfield, MNBuilt 1956 · S/N 23-434 N1385V303 Tango Charlie LLC · Newark, DEBuilt 1984 · S/N T30300266 N13862Reliance Island Inc · Wilmington, DEBuilt 1970 · S/N 27-4500 N13865Enzed Aviation Services LLC · Anchorage, AKS/N 27-4503 N13882Gc Aviation Services-1 LLC · Miamisburg, OHBuilt 1970 · S/N 27-4517

Back to AD 2004-25-16 R1