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.

N15TTray Aircraft Leasing LLC · Port Richey, FLBuilt 1964 · S/N TC-626 N15TDRegistration Pending · Chicago, ILRegistration pendingBuilt 1973 · S/N P-232 N15USale Reported · Van Nuys, CASale reportedBuilt 1979 · S/N ME-160 N15VVLiberty Flying Club Inc Trustee · Wilmington, DEBuilt 1990 · S/N 340A1520 N15WMSidhu Teg Singh · Bakersfield, CAS/N 340A0523 N15XLrb Aviation LLC · Catawba, NCBuilt 1979 · S/N TJ-226 N15XLN15xl LLC · Conway, ARBuilt 1977 · S/N TC-2048 N15YPDepartamento De Educacion Prami · San Juan, PRBuilt 1968 · S/N 27-3966 N15ZPStefenelli Aviation N Tr Inc Trustee · AtterseeS/N 421B0919 N1600TBpm Rentals Inc · Lincoln, CABuilt 1973 · S/N 414-0380 N1603TMedcare Emergency Medical Services Inc · Mcallen, TXBuilt 1973 · S/N 414-0383 N1604MMckinney John Merrill Jr · Bessemer, ALBuilt 1983 · S/N TH1359 N1604WSteve Byrd Aviation LLC · Terrell, TXBuilt 1972 · S/N TH-242 N1606WParagon Airplane Leasing Co · Fort Myers, FLBuilt 1972 · S/N TC-1467 N160CRBas Part Sales LLC · Greeley, COBuilt 1968 · S/N P-24 N160DBAguilar Theodore · Bozeman, MTBuilt 1959 · S/N 23-1670 N160DCPdii LLC · Concord, NCBuilt 1980 · S/N 421C0856 N160MJFoley Robert A · Columbia, NJS/N 30-1410 N160PTPilot Training Center LLC · Miami, FLBuilt 1978 · S/N 44-7995161 N1616TDavila Alexander · Davie, FLS/N 414-0396 N1618TRandolph James · Greensburg, PABuilt 1973 · S/N 414-0398 N161ABSafford Aviation Service Inc · Coolidge, AZBuilt 1977 · S/N TJ-122 N161MRVictor Aircraft Co · Wilmington, DEBuilt 1977 · S/N 27-7754106 N161REVornholt David · New Richmond, OHBuilt 1969 · S/N 30-1952 N161RMTurbine Screws LLC · Bozeman, MTBuilt 1980 · S/N 414A0450 N1621TBeats Driving Inc · Northbrook, ILBuilt 1973 · S/N 414-0401 N1621WColeman Alan · Tyler, TXBuilt 1972 · S/N TC-1455 N1624TMelnik Charles J DBA · Omaha, NES/N 414-0404 N1627TSierra Leasing LLC · Sheffield, ALBuilt 1973 · S/N 414-0407 N16292Morcom Aviation Services Inc DBA · Everett, WABuilt 1973 · S/N 34-7350125 N1629WRegistered aircraftN-number assigned, not yet registeredS/N TH-245 N162BWSimply Living LLC · Fort Myers, FLBuilt 1975 · S/N 34-7570147 N162DFFaford Aviation Leasing Co · Atherton, CABuilt 1982 · S/N TJ-403 N162FRFlying Restaurants LLC · Minot, NDBuilt 1993 · S/N 3448033 N162PCBoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 2018 · S/N 4496429 N162PMFrench Loren · Gypsum, COBuilt 1963 · S/N 30-72 N1637TSmith Taylor · Amarillo, TXBuilt 1973 · S/N 414-0417 N163QGofly Trading LLC · Opa Locka, FLBuilt 1964 · S/N TC-671 N1642WFreeport Supply Co · Wyandotte, MIBuilt 1972 · S/N P-198 N1646TOrellana Willson Daniel · Hesperia, CABuilt 1973 · S/N 414-0426 N1648WKings Aviation Corp · Garden City, NYBuilt 1972 · S/N TH-251 N1652TBas Part Sales LLC · Greeley, COBuilt 1973 · S/N 414-0432 N1659WTrim Aire Aviation Inc · Mexia, TXBuilt 1973 · S/N TC-1475 N165MHFortune Kyle D · Hampstead, NCBuilt 1966 · S/N 310K0173 N165RWCw Aircraft LLC · Atlanta, GABuilt 1964 · S/N TC-683 N165SWN165sw LLC · Lagrange, GAS/N 31T-7904051 N165TTMakushin Logistics LLC · Fairbanks, AKS/N 318452005 N1668TKevu Aviators LLC · Maryville, MOBuilt 1973 · S/N 414-0461 N166ABSafford Aviation Service Inc · Coolidge, AZBuilt 1981 · S/N 34-8133134 N166ACAtlanta Aviation Academy Inc · Lawrenceville, GABuilt 1979 · S/N ME263

Back to AD 2004-25-16 R1