Skip to content

AD 2004-25-16 R1

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.

N92WBZ Aircraft LLC · Seminole, ALBuilt 1970 · S/N TC-1370 N92WH322ee Aviation LLC · Union, KYBuilt 1977 · S/N 340A0271 N9304FSkydive Baltimore LLC · Lincoln, DEBuilt 1985 · S/N 20800008 N9308QMt Zephyr Enterprises LLC · Yorktown, VABuilt 1971 · S/N TC-1411 N930BDMomentum Air LLC · Brighton, MIBuilt 1973 · S/N TH-307 N930ERDodson International Parts Inc · Rantoul, KSFirst renewal noticeBuilt 2002 · S/N 4496154 N930LTAerosim Flight Academy · Sanford, FLBuilt 2018 · S/N 4496418 N930MDTab Associates Inc DBA · Port Saint Lucie, FLBuilt 1967 · S/N 27-3787 N9310QMc Types II LLC · Jacksonville, FLBuilt 1971 · S/N TH-180 N9314FMission Aviation Fellowship · Nampa, IDBuilt 1985 · S/N 20800010 N931EJetco Leasing · Salinas, CABuilt 1966 · S/N TC-1009 N931LTAerosim Flight Academy · Sanford, FLBuilt 2018 · S/N 4496419 N931SAMarc Inc · Bolton, MSBuilt 1975 · S/N 317552036 N931VBaker Matthew T · Shipman, ILBuilt 1974 · S/N TC-1764 N9320QT-Wing Aviation LLC · Pompton Plains, NJBuilt 1971 · S/N TC-1413 N9326QLoyd Tracy · Broken Arrow, OKBuilt 1971 · S/N TH-186 N932FSAviation Equipment Co LLC · Lincoln, NES/N 44-7995018 N932LTAerosim Flight Academy · Sanford, FLBuilt 2018 · S/N 4496420 N9330TCrusader 303 LLC · Eugene, ORBuilt 1981 · S/N T30300002 N9333KOrlandi Properties LLC · Blairstown, NJBuilt 1976 · S/N 34-7670198 N933JMSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1982 · S/N 44-8207009 N933LTAerosim Flight Academy · Sanford, FLBuilt 2018 · S/N 4496421 N9340QH O C Investments LLC · Garden City, KSBuilt 1971 · S/N TC-1412 N934CRReygar Investments LLC · Brownsville, TXBuilt 1982 · S/N 414A0856 N934LTAerosim Flight Academy · Sanford, FLBuilt 2018 · S/N 4496422 N934SBLac Aero LLC · Liberal, KSBuilt 1978 · S/N 34-7970061 N935CWIn Flight Aircraft LLC · Howell, MIBuilt 2005 · S/N 4496213 N935ERChristiansen Aviation LLC · Wilmington, DEBuilt 2005 · S/N 4496195 N935LTAerosim Flight Academy · Sanford, FLBuilt 2018 · S/N 4496423 N936AFVasquez Ahyde E · Brownsville, TXS/N 421C0606 N936JBHunt Air LLC · Anderson, SCBuilt 1977 · S/N 340A0263 N936LTAerosim Flight Academy · Sanford, FLBuilt 2018 · S/N 4496424 N936RGrandinetti Robert L · Fayetteville, NYBuilt 1967 · S/N 30-1580 N937LTAerosim Flight Academy · Sanford, FLBuilt 2018 · S/N 4496425 N937TTPlanemarketing LLC · Vero Beach, FLFirst renewal noticeBuilt 1977 · S/N 31T-7720037 N937VNabarrette Angel · Odessa, TXBuilt 1975 · S/N TC-1879 N9385QOxer James E · Lake Placid, FLBuilt 1970 · S/N TH-49 N938LTAerosim Flight Academy · Sanford, FLBuilt 2018 · S/N 4496426 N938PMD & B Aviation LLC · Stroudsburg, PABuilt 1983 · S/N 31-8452013 N938VParlin Troy W · Wills Point, TXBuilt 1975 · S/N TC-1835 N939AZAz2025 LLC · Miami, FLBuilt 1972 · S/N 34-7250168 N939LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 4496484 N93BDColeman William R · Jasper, ARBuilt 1967 · S/N 30-1433 N93JGClassy Aircraft Inc · VictoriaBuilt 1965 · S/N 310J0063 N93JNPj Aviation Holding LLC Trustee · Eden Prairie, MNBuilt 1980 · S/N 34-8070175 N93MVWell Bilt Industries USA LLC · Ocala, FLBuilt 1979 · S/N 27-8054029 N93PAIsbell Brian K · Rosenberg, TXBuilt 1982 · S/N 44-8207015 N93SHBasin Air LLC · Mattawa, WAFirst renewal noticeS/N 31T-7904029 N93TSky Masters Inc · Bonner Springs, KSS/N TC-1051 N93UGBellas Business LLC · Kalispell, MTS/N 23-350

Back to AD 2004-25-16 R1