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.

N120MLMrl Aviation LLC · Wilmington, DEBuilt 1977 · S/N 31-7752091 N120RHAir Puerto Rico Corp · Aguadilla, PRBuilt 1978 · S/N 44-7995118 N1210PRegistration Pending · Independence, MORegistration pendingBuilt 1955 · S/N 23-226 N1213SWright Caravan LLC · Seattle, WABuilt 1995 · S/N 20800243 N1214G9791m LLC · Tacoma, WABuilt 1975 · S/N 414-0652 N1215PTucker Robert B · Melba, IDBuilt 1955 · S/N 23-234 N1216GNeel Aviation LLC · Lakeland, FLS/N 414-0653 N1217Pendley Rory G · Torrance, CABuilt 1955 · S/N 23-237 N1219TLrh Equipment LLC · Pendleton, ORBuilt 1972 · S/N 34-7250265 N121AFEway William · Jupiter, FLBuilt 1981 · S/N TH-1254 N121AQPacker William M III Trustee · Orchard Lake, MIS/N 421C1063 N121BDKorn Air LLC · Fort Lauderdale, FLS/N 414A0297 N121BLOlson Brian D · Las Vegas, NVBuilt 1982 · S/N TJ-413 N121BWLester Jon M · Lancaster, OHBuilt 1979 · S/N TC-2256 N121CBClark Andrew R · Woodside, CABuilt 1976 · S/N 340A0087 N121DRJohnson And Son Enterprises · Dunn, NCBuilt 1974 · S/N 310Q1046 N121GJ424 Ventures LLC · Saint Petersburg, FLBuilt 1976 · S/N TJ-62 N121LATgl Inc · Wilmington, DEBuilt 1973 · S/N 310Q0973 N121LGPayton Kathleen · Grand View, IDBuilt 1964 · S/N TC-777 N121SLLadet David E · Lavonia, GABuilt 1969 · S/N 27-4475 N121WAWeather Modification LLC · Fargo, NDBuilt 1979 · S/N 34-7970435 N1220BWash Steven M · Austin, TXBuilt 1957 · S/N 23-1161 N1221KAirline Transport Professionals Corp Of USA · Wilmington, DES/N 44-7995295 N1223HS&S Leasing Solutions LLC · Sandy Springs, GABuilt 1973 · S/N 421B0365 N1225MMarlin Roger · Morgan Hill, CABuilt 1971 · S/N 33701425 N1228GMcdaniel Dean K · Mesa, AZBuilt 1974 · S/N 310Q1081 N1229TPiper Electric Inc · Deer Park, NYBuilt 1972 · S/N 34-7250267 N1229XTalkeetna Aero Services Inc · Anchorage, AKBuilt 1992 · S/N 20800212 N122AMHarper David · New Richmond, WIBuilt 1973 · S/N 310Q0943 N122AWAztec Worldwide Airlines Inc · Wilmington, DEBuilt 1976 · S/N 31-7652135 N122DDBeacon Hill Leasing LLC · Plymouth, MIBuilt 1977 · S/N 27-7754120 N122EOne Two Two Echo Aviation LLC · Cincinnati, OHBuilt 1973 · S/N 310Q0984 N122RLJenaero LLC · Cincinnati, OHBuilt 1978 · S/N TC-2177 N122RMHolland Mark Drew · San Antonio, TXBuilt 1984 · S/N TH-1416 N122SWAmerican Petroleum Corp · Ratliff City, OKS/N 421B0506 N122WB2sea2it LLC · Ossining, NYBuilt 1973 · S/N 33701487 N1230TWings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 34-7250268 N1231PTwin Oaks Airpark Inc · Hillsboro, ORBuilt 1955 · S/N 23-251 N1232KCorporate Air LLC · West Mifflin, PABuilt 1984 · S/N 340A1815 N1234PThomas Steven E · Libertyville, ILBuilt 1955 · S/N 23-255 N1234UInternational Air Services Inc Trustee · Carson City, NVS/N 348070336 N1234WCuellar Mauricio Dominguez · Tampa, FLBuilt 1970 · S/N 414-0043 N1236Entwistle Brian V · Knoxville, TNS/N 30-1167 N1238RLtx Consulting LLC · Austin, TXBuilt 1977 · S/N 340A-0272 N1239TPhoenix East Aviation LLC · Daytona Beach, FLBuilt 1972 · S/N 34-7250270 N123AKOptima Aviation LLC DBA · Lewisville, TXBuilt 1973 · S/N TC-1543 N123AMC W Myers Holdings LLC · Anthony, NMBuilt 1973 · S/N 340-0245 N123APJc Air Academy Inc · Stockton, CABuilt 1977 · S/N 34-7770015 N123BARothschild Jonathan Trustee · Tucson, AZS/N 414A-0065 N123BCBlue River Baron 58 LLC · Malcolm, NEBuilt 1977 · S/N TK-41

Back to AD 2004-25-16 R1