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.

N43010Nahigian J Victor · Weston, MABuilt 1983 · S/N 34-8333075 N4301C70 North LLC · Anchorage, AKBuilt 1983 · S/N 31-8353001 N4302NAtlantic Aircraft Holdings LLC · Bohemia, NYS/N 34-8333073 N4302YLundstedt Gregory · Duncan, SCBuilt 1961 · S/N 23-2025 N43034A S Flight Academy LLC · Lantana, FLBuilt 1974 · S/N 34-7450175 N4303WDickhead Aviation LLC · Smithfield, NCBuilt 1983 · S/N 34-8433016 N4304CN4304c LLC · Pawhuskah, OKBuilt 1980 · S/N 340A1011 N4304XC W Rose Flight LLC · Wilmington, DEBuilt 1976 · S/N 34-7670018 N4306YRegistration Pending · Phoenix, AZRegistration pendingBuilt 1961 · S/N 23-2029 N4307PGibson Kim · Ocean Springs, MSBuilt 1959 · S/N 23-1808 N4308ZMike Victor Yankee LLC · Andover, MABuilt 1983 · S/N T30300183 N4309PSibille Philippe B · Waller, TXBuilt 1959 · S/N 23-1810 N430RTTortorigi Aviation LLC · Birmingham, ALBuilt 1984 · S/N TH-1411 N430RVVermejo Aviation LLC · Boulder, COBuilt 2004 · S/N TH-2097 N430TXTexas Department Of Public Safety · Austin, TXBuilt 2021 · S/N 20800682 N4310PChimera Air Inc · Maumee, OHBuilt 1959 · S/N 23-1811 N4310WSt Clair Joseph M · Wills Point, TXBuilt 1974 · S/N TC-1651 N4311PRitchie Glenn R · King George, VAS/N 23-1812 N4311UMoreland Wesley M · Mckinney, TXBuilt 1965 · S/N 337-0093 N4312YWhittom Ron W Jr · Wasilla, AKS/N 23-2036 N43130University Of Maryland Eastern Shore · Princess Anne, MDBuilt 1974 · S/N 34-7450180 N43134Minot Aero Center · Minot, NDS/N 34-7450150 N4315COld Salt Aviation LLC · Virginia Beach, VABuilt 1978 · S/N 340A0532 N4316USkyborne Airline Academy Inc · Vero Beach, FLBuilt 2002 · S/N 4496119 N4319SMac Air Inc · Farmington, MOBuilt 1975 · S/N TC-1869 N431BRLockyer Roch Jr · Austin, TXBuilt 1970 · S/N 310Q0221 N431CELegacy Aviation LLC · Ann Arbor, MIBuilt 1973 · S/N 414-0431 N432Lazy J Aeroplanes LLC · Beverly, WVBuilt 1974 · S/N TC-1649 N4321YSchuermann Chris L · Sand Springs, OKBuilt 1965 · S/N 27-607 N43225Gann Clifton T · Guthrie, OKS/N 34-8433006 N4322TKing Kong Broadcasting Inc · Las Vegas, NVBuilt 1964 · S/N 27-2524 N4324DHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1983 · S/N 34-8433019 N4324VTriple Aaa LLC · Garden City, KSBuilt 2001 · S/N TH-2014 N4324YLima Whiskey LLC · Aberdeen, SDS/N 34-8433023 N4326CSeven Echo Whiskey Corp · Wilmington, DEBuilt 1976 · S/N 340A0075 N4327NFederal Fire And Security LLC · Owensboro, KYBuilt 1983 · S/N 34-8433026 N4329YDetert Bradley · Valparaiso, INBuilt 1966 · S/N 27-619 N432BEvans Ferguson · Washington, DCBuilt 1965 · S/N 310J0041 N432CWValiair Lc Trustee · Casper, WYBuilt 1975 · S/N 31-7512012 N432DLWhitecotton William W · Eldersburg, MDBuilt 1974 · S/N TH-561 N432RADirect Entry Holdings LLC · Port Richey, FLBuilt 1979 · S/N 340A0925 N432SAMma Consulting Inc · Chestnut Hill, MABuilt 2002 · S/N 3449232 N4331WRicca Gregory F Trustee · Bentonville, ARBuilt 1974 · S/N TH-436 N4333GHuebscher Attila · Pittstown, NJBuilt 1984 · S/N 34-8433048 N4333PTinny Twister Aviation LLC · Fort Myers, FLBuilt 1959 · S/N 23-1834 N4334PWelke Aviation Inc · St James, MIBuilt 1959 · S/N 23-1835 N4337WPeterson Arnold L · Gardnerville, NVBuilt 1974 · S/N TC-1665 N43394Skyline Solutions Inc · Deland, FLS/N 34-7450186 N433DBBarnes Creek Drilling LLC · Columbia, MSBuilt 1974 · S/N 31P-7400228 N433PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 4496063

Back to AD 2004-25-16 R1