Registered aircraft · 10,537

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.

N558BTKeesling Roger L · Starkville, MSBuilt 1969 · S/N 310P0220 N558CBFrancis Scott P · Montclair, VAS/N TC-1800 N558CMWells Airways LLC · Austin, TXBuilt 1978 · S/N 34-7870290 N558PSouth Electrical Inc · Laurinburg, NCBuilt 1982 · S/N TJ-421 N558RSAyelet Aviation LLC · Mackinac Island, MIBuilt 1977 · S/N TK-67 N558RT558rt LLC · Rocky Mount, NCBuilt 1993 · S/N TH-1691 N558THScannelli Jeff · Southampton, NYBuilt 2001 · S/N TH-2000 N558WHRex Aero LLC · Wilmington, DEBuilt 1982 · S/N TH-1356 N5591ABig Dog I LLC · Wallace, MIBuilt 1989 · S/N TH-1566 N55928Tao Aviation LLC · Las Vegas, NVS/N 34-7350261 N55970Soaring Eagle Aviation LLC · Carmi, ILBuilt 1973 · S/N 34-7350266 N559BERegistered aircraftBuilt 2024 · S/N 20800708 N559CInternational Air Services Inc Trustee · Carson City, NVS/N 3449238 N559JTOrian Dillon R · Malibu, CABuilt 1960 · S/N 27-286 N559MKBadawi Aviation LLC · Orlando, FLBuilt 1979 · S/N ME170 N55AGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1965 · S/N 30-804 N55BNInternational Air Services Inc Trustee · Carson City, NVBuilt 1973 · S/N TC-1572 N55BUBlue Side Up LLC · Oxford, CTBuilt 1978 · S/N TC-2138 N55CLBoyd Larry C · Seymour, TXBuilt 1969 · S/N P-77 N55CMCamille Ventures LLC · Odessa, TXBuilt 1973 · S/N 4140423 N55CNBaron 55cn LLC · Haltom City, TXBuilt 1964 · S/N TC-601 N55CSHammond Neil K · Manhattan, KSBuilt 1965 · S/N 337-0222 N55CZHall William · Boynton Beach, FLBuilt 1976 · S/N TC-1932 N55FDDieu Est Mon Courage LLC · Fernandina Beach, FLBuilt 1975 · S/N TC-1857 N55HMMoore Brian L · Reno, NVBuilt 1974 · S/N TC-1723 N55JELakes Area Aviation LLC · Little Falls, MNS/N 23-772 N55KJHope For Bethesda · Orange Park, FLBuilt 1977 · S/N TK-40 N55LTRegistration Pending · Tucson, AZRegistration pendingS/N 414-0926 N55MLAlmeida Gabriel · Bellville, TXBuilt 1964 · S/N TC-691 N55MTKramp William J · Post Falls, IDBuilt 1966 · S/N 27-3575 N55PBHorizon Dreams LLC · Homer, GABuilt 1962 · S/N 27-2184 N55PPChaffey Community College District · Rancho Cucamonga, CABuilt 1972 · S/N 414-0366 N55RPneuma Aviation LLC · New Orleans, LABuilt 1976 · S/N 31T-7620055 N55RBGots To Go LLC · Wilmington, DEBuilt 1975 · S/N 340A0015 N55RDSchober David · Union Bridge, MDBuilt 1966 · S/N 30-1307 N55RLSound Harbor Aviation LLC · Wilmington, NCS/N 421C1071 N55RVRegistration Pending · Dover, DERegistration pendingBuilt 1975 · S/N TC-1828 N55SEN55se LLC · Frankfort, ILBuilt 1968 · S/N TC-1136 N55SGBas Part Sales LLC · Greeley, COBuilt 1976 · S/N TC-1955 N55SJBk Air LLC · New Brighton, MNBuilt 1982 · S/N TC-2447 N55TEMaxwell Aviation Inc · Chesterfield, MOFirst renewal noticeBuilt 1975 · S/N TC-1832 N55TMThomas Kurtis · Lubbock, TXBuilt 1978 · S/N TH-901 N55VFTjp Aviation Inc · Garrettsville, OHBuilt 1978 · S/N TC-2132 N55VGA And E Aero Ventures LLC · Saline, MIBuilt 1978 · S/N TC-2165 N55VVMcnitt Todd M · Newport, ORBuilt 1968 · S/N P-20 N55WSFour To One LLC · Decatur, ALBuilt 1976 · S/N 421C0073 N56000Wings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 34-7350270 N560DBAnderson Aerial Spraying Svc Inc · Canby, MNBuilt 1964 · S/N 27-2722 N560XWullschleger Kevin D · Avon, INBuilt 1965 · S/N TC-968 N5612KUptime Electonics Inc · Whittier, CABuilt 1964 · S/N TC-604

Back to AD 2004-25-16 R1