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.

N7120EFlightgest Academy LLC · Morrisville, NCBuilt 2021 · S/N 4496471 N7120YRoyal Ryan M · Lincoln, NEBuilt 1963 · S/N 30-139 N7121YUhlemeyer William A · Alvin, TXBuilt 1963 · S/N 30-140 N7122EChristiansen Aviation LLC · Wilmington, DEBuilt 2018 · S/N 4496447 N7122YSutton Jack M · Jesup, GABuilt 1963 · S/N 30-141 N7123NLarson Sven E · Newport Coast, CABuilt 1967 · S/N TC-1046 N7126GHenry Rolla G Jr · Saint Charles, MOBuilt 1966 · S/N 30-1001 N7127YSpencer Avionics Inc · Spencer, IABuilt 1963 · S/N 30-148 N7128YAir Mods And Repair Corp · Robbinsville, NJBuilt 1963 · S/N 30-149 N7129YButner Gary W · Yuba City, CABuilt 1963 · S/N 30-151 N712BPPearson Matthew G · Wickenburg, AZBuilt 1973 · S/N TC-1520 N712GDOsborne David · Texarkana, ARBuilt 1980 · S/N TH-1107 N712GLThere And Back LLC · Tulsa, OKBuilt 1975 · S/N 340A0029 N712JDCpch Aviation LLC · Jacksonville, FLS/N 421C0908 N712JFN712jf LLC · Laveen, AZBuilt 1968 · S/N 337-0859 N712JTSkylens LLC · Hammond, LABuilt 1979 · S/N 27-7954057 N712JWFalcon & Phoenix Aviation LLC · Las Vegas, NVBuilt 1969 · S/N 421A0128 N712JZHeffley Brothers Flying Circus LLC · Benbrook, TXBuilt 1975 · S/N TH-671 N712LSDwyer Stephen C · The Woodlands, TXBuilt 1979 · S/N TJ-192 N712TMHudson Valley Helicopter Flight Services LLC · Salt Point, NYBuilt 1979 · S/N 27-7954083 N7130NBlake Charles L · Woodstock, GABuilt 1968 · S/N TC-1059 N7131YGreat Lakes Air Ventures LLC · Mason, MIBuilt 1963 · S/N 30-153 N7135GRegistered aircraftBuilt 1977 · S/N 421C0284 N7136FCms Utility Services Inc · Punta Gorda, FLS/N 34-7770053 N7136YSchilling Stephen V · Rockford, ILBuilt 1963 · S/N 30-158 N713ECCharlie Tango LLC · Mechanicsville, VABuilt 1975 · S/N 27-7554151 N713MFBoundless Aviation LLC · Wilmington, DEBuilt 1973 · S/N 310Q0785 N713VUhlik Daniel · Delano, CABuilt 1968 · S/N P-16 N713VSJrr Professional Services LLC · Davie, FLBuilt 1974 · S/N 277405415 N713WTWtw Air LLC · Houston, TXBuilt 1977 · S/N 31-7752138 N7147YLee A Archer Jr Red Tail Youth Flying Program Inc · New Windsor, NYBuilt 1963 · S/N 30-164 N71481Jib Inc · Groton, CTS/N 31-8352029 N714UZwicker Brian A · Richmond Hill, GABuilt 1968 · S/N TC-1188 N7151NStroope Rhea H · Campbell, TXBuilt 1968 · S/N TC-1062 N71544Miller Family Enterprises LLC · Humble, TXS/N 421B0552 N7155YSheasley George · Eagle Creek, ORFirst renewal noticeBuilt 1963 · S/N 30-173 N7157YTailwind Consulting LLC · Port Orange, FLS/N 30-175 N7159YPepmiller Scott C · Panama City Beach, FLS/N 30-177 N715AJA&J Air Sales Inc · San Antonio, TXS/N 31-7405405 N715BDBlack Thomas D · Clearwater, FLBuilt 1976 · S/N 34-7670133 N715LCNadon-Rzasa Jason Z · Tucson, AZBuilt 1963 · S/N 310H-0094 N7162CWyoming Valley Air LLC · Old Forge, PABuilt 1975 · S/N 34-7570301 N7163YBoyd John W · Milton, WABuilt 1963 · S/N 30-184 N7164DAir Arctic Inc · Fairbanks, AKBuilt 1980 · S/N 31-8052013 N7164YGreat Lakes Air Ventures LLC · Mason, MIBuilt 1963 · S/N 30-185 N7166KKellar John C · Runaway Bay, TXBuilt 1975 · S/N TH649 N7166YCollum Aviation LLC · Milton, FLBuilt 1963 · S/N 30-187 N7167YThomas Thomas J · Lewisburg, WVBuilt 1963 · S/N 30-188 N716ESFlorida Fish And Wildlife Conservation Commission · Lakeland, FLBuilt 2023 · S/N 20800694 N716RMMattracks Promotions Inc · Karlstad, MNBuilt 1974 · S/N 421B-0528

Back to AD 2004-25-16 R1