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.

N7846RLewis Paul Randell · Eastman, GABuilt 1969 · S/N TC-1205 N784LULiberty University School Of Aeronautics · Lynchburg, VABuilt 2016 · S/N 4496396 N7852YBordlemay John J · Lewisberry, PABuilt 1965 · S/N 30-932 N7855YParrish Aviation Flight Academy LLC · Southlake, TXBuilt 1965 · S/N 30-936 N7856YEastern Technical Corp · Martinsburg, WVBuilt 1965 · S/N 30-937 N7858PRegistered aircraftBuilt 1978 · S/N TJ-183 N7858YGraham Stuart H · Heath, OHBuilt 1965 · S/N 30-778 N785CGWings Of Victory Worldwide LLC · Apopka, FLS/N 34-7770351 N785LULiberty University · Lynchburg, VABuilt 2018 · S/N 4496433 N785NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2016 · S/N 4496399 N7861Y7861y LLC · Long Beach, CAS/N 30-942 N7862YSteiger Michael P · Cypress, TXBuilt 1965 · S/N 30-944 N7863YSlipshod Aviation LLC · Hurricane, UTBuilt 1965 · S/N 30-945 N7864YVavra Loren · Phoenix, AZFirst renewal noticeBuilt 1965 · S/N 30-946 N7865YMussman Craig L · Grant Park, ILBuilt 1965 · S/N 30-948 N7866YHenrie Aviation LLC · Fairfield, NJBuilt 1965 · S/N 30-949 N7869RRegistered aircraftBuilt 1969 · S/N TC-1209 N786AAtp Aircraft 2 LLC · Wilmington, DEBuilt 1997 · S/N 4496016 N786MSKing Kimberly A · Kensington, NHBuilt 1999 · S/N 3449114 N7871YDow Jeff W · Port Hadlock, WAS/N 30-955 N7872QSinkovich Peter I · Phoenix, AZBuilt 1972 · S/N 310Q0653 N7873LMcguire David · Sandston, VABuilt 1966 · S/N TC-1018 N7873QWallis Aircraft Inc · Clifford Township, PABuilt 1972 · S/N 310Q0654 N7875YDodson Carl F · Jasper, INBuilt 1965 · S/N 30-959 N787AUAuburn University · Auburn, ALBuilt 2019 · S/N 4496457 N787CCMegaship Ventures LLC · Baytown, TXBuilt 1985 · S/N TH-1490 N787DRBad Aire LLC · Aledo, TXS/N 414A0503 N787GSwirsding David J · Chalfont, PABuilt 1979 · S/N 340A0961 N787PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 1972 · S/N 34-7350033 N787RWJw Venture Aviation LLC · Concord, NCS/N 31-7652087 N787WAJw Aero Holdings Inc · Canandaigua, NYBuilt 1980 · S/N 348070057 N7883YHoward Jerry W · Snellville, GABuilt 1965 · S/N 30-968 N7885YKregel Steven · Garnavillo, IABuilt 1965 · S/N 30-970 N7887QBeiser Ned E · De Soto, TXBuilt 1972 · S/N 310Q0659 N7887YAskins Jack C · Wichita Falls, TXBuilt 1966 · S/N 30-973 N7888YBurkel Robert G · Hemet, CABuilt 1966 · S/N 30-975 N788BGSeminole Aircraft LLC · Wilmington, DEBuilt 2002 · S/N 4496143 N788CF3w Group Inc · Hot Springs, ARBuilt 1977 · S/N TH-870 N788DMSts Aviation LLC · Daytona Beach, FLBuilt 1978 · S/N 340A0461 N788JJGreenlee Joseph A III · Fort Wayne, INBuilt 1975 · S/N 421B0851 N7890YMhr Leasing LLC · Hickory Corners, MIBuilt 1966 · S/N 30-977 N7892YHarrison Richard J · South Hamilton, MABuilt 1966 · S/N 30-979 N7893QDatchcorr LLC · Chattanooga, TNBuilt 1972 · S/N 310Q0661 N7893YRegistered aircraftBuilt 1966 · S/N 30-980 N7898PSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1969 · S/N 301873 N7898YPatry Aeronautical Institute · Kalispell, MTBuilt 1966 · S/N 30-986 N7899QCounty Farms LLC · Mars Hill, MEBuilt 1972 · S/N 310Q0619 N789AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2025 · S/N 4496623 N789MD340a1021 Inc Trustee · Wilmington, DEBuilt 1980 · S/N 340A1021 N789PTValiair Limited Company · Casper, WYBuilt 1985 · S/N 414A1209

Back to AD 2004-25-16 R1