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.

N5YBFrasier Samuel R · Gainesville, FLS/N TC-952 N5YFBas Part Sales LLC · Greeley, COBuilt 1967 · S/N 310L-0084 N5ZRBeasley Timber Co Inc · Hazlehurst, GABuilt 2005 · S/N TH-2128 N5ZTAllen Airplane LLC · Durango, COBuilt 1973 · S/N 414-0477 N6000PMoseley Timothy D · Calhoun, KYBuilt 1957 · S/N 23-1236 N6001RSorbi Aviation Inc · El Cajon, CABuilt 1978 · S/N ME-118 N6001YPilots Choice Aviation Equipment Leasing Co · Georgetown, TXBuilt 1978 · S/N ME-119 N6002CChristiansen Aviation LLC · Wilmington, DEBuilt 1978 · S/N ME-120 N6002KJet & Rotor Aviation LLC · Sacramento, CABuilt 1978 · S/N ME-122 N6002LBadawi Aviation LLC · Orlando, FLBuilt 1978 · S/N ME-123 N6003RRemikin I LLC · Naperville, ILS/N ME-126 N6003YAri Ben Aviator Inc · Fort Pierce, FLBuilt 1978 · S/N ME-129 N60041Chino Farms Aviation LLC · Valley Center, CABuilt 2026 · S/N 20800726 N6006DLedda Francesco · Canton, TXBuilt 1979 · S/N ME-133 N6008XMangum Gary W · Centreville, VABuilt 1969 · S/N 301836 N600BBGat Air & Ground LLC · Norwich, NYFirst renewal noticeBuilt 1981 · S/N TH-1236 N600DCHerron Aviation Group LLC · Dexter, MIS/N 421C1007 N600EXAire Tracks Corp · Wilmington, DEBuilt 1969 · S/N 310P0147 N600HCCessna 414a LLC · Portland, ORBuilt 1978 · S/N 414A0025 N600MBKleid Kenneth E · Spring Branch, TXBuilt 1968 · S/N TC-1184 N600PAHeaven'S Landing Realty Inc · Clayton, GABuilt 1980 · S/N TJ-250 N600PMBlackford Ryan · Manchester, TNBuilt 1977 · S/N TC-2082 N600PRWest Wind Air LLC · Lake Village, ARBuilt 1981 · S/N TC-2384 N600RJRankin Richard · Germantown, TNBuilt 1979 · S/N 27-7954114 N600RRCompac Inc · Manassas, VABuilt 1963 · S/N 310H0108 N600RVAero-Tech Services Inc · Lititz, PABuilt 1998 · S/N TH-1854 N600SMCapt Tony 185 LLC · Aurora, COBuilt 1966 · S/N 320E0084 N600THN600th LLC · Fredericksburg, VABuilt 1981 · S/N 414A0668 N6011QHikari Aviation Ltd · Torrance, CABuilt 1978 · S/N ME-100 N6011UJin Jin Aviation LLC · Anchorage, AKBuilt 1978 · S/N ME-101 N6011YTab Associates Inc DBA · Port Saint Lucie, FLBuilt 1966 · S/N 27-3193 N6012SWhaley Carl S · Shelby, NCS/N TJ-15 N6013FMile Fly Club LLC · Gainesville, TXBuilt 1965 · S/N TC-888 N6013ZVandelay Aviation LLC · San Diego, CABuilt 1978 · S/N ME-112 N60156Shannon School Of Aeronautics LLC · Fredericksburg, VABuilt 1979 · S/N ME-147 N6015QBohlke LLC · Kingshill, VIBuilt 1979 · S/N ME-141 N6015ZOsorio Aviation Corp · Miami, FLNon-citizen corporation, flight hours not reportedBuilt 1979 · S/N ME-145 N6016UAbbasi Babak · Escondido, CABuilt 1979 · S/N ME-156 N6017SEisma Thomas Eugene · Golden, COBuilt 1975 · S/N TJ-17 N6017YTulsa Technology Center School District No 18 · Tulsa, OKS/N 27-3200 N6018SJohnson Thomas G · New Port Richey, FLS/N TJ-19 N601AJShamrock Aviation LLC · Madison, MSBuilt 1984 · S/N 31T-1104013 N601JBNixon Penny R · Wasilla, AKFirst renewal noticeBuilt 1977 · S/N 34-7770184 N601RKNorthampton Aeronautics Inc · Northampton, MABuilt 1978 · S/N ME-71 N60244Ace Of Spades Aviation LLC · Las Vegas, NVBuilt 1978 · S/N ME-130 N6024KNabarrette Angel · Odessa, TXBuilt 1979 · S/N TJ-187 N6024QAero Equities LLC · Ventura, CABuilt 1979 · S/N TC-2209 N6024SAdams Erik S · Bozeman, MTBuilt 1975 · S/N TJ-16 N6024U6024u Aircraft Leasing LLC · Spanish Fork, UTBuilt 1979 · S/N TC-2210 N6026HMiami Valley Career Technology Center · Englewood, OHS/N 34-7870047

Back to AD 2004-25-16 R1