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.

N1267GChesnut James Scott · Oak Point, TXBuilt 1974 · S/N 310Q1118 N126BTSecure Storage Solutions LLC · Thomaston, GABuilt 1977 · S/N 4140909 N126DRForbis Michael · Calera, OKBuilt 1974 · S/N 31-7405173 N126MAWinter Kristin A · Spring Lake Park, MNBuilt 1969 · S/N 30-1865 N126MLL3 Cts Airline Academy · Sanford, FLBuilt 2019 · S/N 4496481 N126PFPylant Ruth A · Lubbock, TXS/N 30-1122 N126TKLoftis Chris · Fort Worth, TXBuilt 1980 · S/N TK-126 N1271GSee Christopher · Owenton, KYS/N 310Q1122 N1271PWendt Aero LLC · Newberg, ORBuilt 1955 · S/N 23-301 N1273PMatthews Grover C · Fairborn, OHBuilt 1955 · S/N 23-304 N1275MAdams Charles P · New London, NHBuilt 1970 · S/N 33701275 N1276GCarter Joseph C · Brookline, NHBuilt 1974 · S/N 310Q1126 N1276VNew Horizon Aviation Inc · Warwick, RIBuilt 1984 · S/N T30300262 N1277MWilliams Richard A · Brookhaven, GABuilt 1970 · S/N 33701277 N1278HMetzner Brad · Visalia, CAS/N 34-7770118 N1279GHodgman Gary W · Greenville, TXBuilt 1974 · S/N 310Q1129 N127ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496035 N127FCalifornia In Nice Inc · San Jose, CABuilt 1965 · S/N TC-869 N127RWWindmiller David · Melville, NYBuilt 1976 · S/N TC-1958 N1281MWadleigh John M · Marana, AZBuilt 1970 · S/N 33701281 N1288MRagsdale Michael R · Eustis, FLS/N 33701288 N128ARGeorge'S Aviation Services Inc · Honolulu, HIBuilt 2005 · S/N 4496218 N128BRNautilus Aviation LLC · Yadkinville, NCBuilt 1979 · S/N 414A0231 N128LBWareham Andrew John · Wasilla, AKBuilt 1966 · S/N 30-1132 N128MCDawson Aircraft Inc · Clinton, ARBuilt 1984 · S/N 340A1808 N128MGHastings Gladstone E · Miramar, FLS/N 31-7712074 N128MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 4496171 N128WSSkyway Air Taxi LLC · Manassas, VABuilt 2001 · S/N TH-1982 N1292GBahig Saliba · Scottsdale, AZBuilt 1974 · S/N 310Q1141 N1292PEm Turbines Corp · Fort Lauderdale, FLS/N 23-327 N1293TN1293t LLC · Wilmington, DES/N 34-7250283 N1293VEgmond Aircraft LLC · Lewes, DES/N 310Q1038 N129AGMarsh Equipment LLC · Aurora, ORBuilt 2024 · S/N 4496574 N129AVCochran Jeffrey · Lincoln, NEBuilt 1980 · S/N 34-8070309 N129DPSplendid Air Leasing LLC · Corpus Christi, TXS/N 310L-0006 N129LCL R & F LLC · Dover, DEBuilt 1979 · S/N 31T7904042 N129MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 4496172 N129QFlying J Aviation Pllc · League City, TXS/N TC-847 N129STAzell LLC · Springfield, MOBuilt 1965 · S/N TC-835 N12BGFull Scale Aviation LLC · Mccordsville, INBuilt 1982 · S/N TC-2412 N12CRTrudnak Michael W · Mansfield Center, CTBuilt 1977 · S/N 421C0279 N12CYYeagle Aviation Inc · Port Saint Lucie, FLBuilt 1971 · S/N 310Q0247 N12FSLawley Frederick E · Bozeman, MTBuilt 1966 · S/N 30-1226 N12GEJ&P Master Flooring Corp · Lauderdale Lakes, FLBuilt 1974 · S/N 27-7405422 N12GFStauffer Michael S · Wichita Falls, TXBuilt 1973 · S/N 31P-7300134 N12JLGiber Kristofor D · Manvel, TXBuilt 1961 · S/N 27-404 N12KNJane Air LLC · Kalamazoo, MIBuilt 1968 · S/N 421-0130 N12MKIndus Health Inc · Santa Clara, CAS/N 421C0421 N12MPMarcus Robert L · Dallas, TXBuilt 1963 · S/N 30-284 N12MTRegistration Pending · Mount Vernon, IARegistration pendingBuilt 1978 · S/N TC2119

Back to AD 2004-25-16 R1