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.

N72361Innovative Solutions Inc · Edmond, OKBuilt 1973 · S/N 33701568 N72370Vinland Aerodrome Inc · Baldwin City, KSS/N 33701570 N7238LHorizon Flight Center LLC · Chesapeake, VABuilt 1981 · S/N ME-433 N7239RGenesis Aviation Enterprises Inc · Fort Lauderdale, FLS/N TH-565 N723DBRegistered aircraftBuilt 1966 · S/N TC-1019 N723ESEs Owens LLC · Mustang, OKBuilt 1982 · S/N 421C1217 N723JPTiffin Aire Inc · Tiffin, OHBuilt 1978 · S/N 31T-7920009 N723JSAlbertson James M · Westville, FLBuilt 1967 · S/N 30-1512 N723KYCommonwealth Of Kentucky · Frankfort, KYBuilt 1978 · S/N 31-7852122 N723RANeron II LLC · Lewes, DES/N 34-7350090 N72403Drury Edward D · Little Silver, NJS/N 33701576 N72406Mercer Don G · Hendersonville, TNBuilt 1973 · S/N 33701577 N7240YHodges David S · Reidsville, GABuilt 1964 · S/N 30-264 N72432Kaono Jerry C · Carson, CABuilt 1973 · S/N 33701581 N7243ABc Express LLC · Santa Barbara, CAS/N TJ-494 N72444Valiair Lc LLC Trustee · Casper, WYS/N 33701586 N72446Minerals 66 LLC · Molt, MTBuilt 1973 · S/N 33701587 N7244RContract Fabricators Inc · Holly Springs, MSBuilt 1975 · S/N TH-558 N7244YJ Mac Aviation Services LLC · Andalusia, ALBuilt 1964 · S/N 30-269 N7246YMoyer Thomas L · Fayetteville, GABuilt 1964 · S/N 30-271 N72474Dick Ronald J · Fort Wayne, INBuilt 1974 · S/N 33701597 N7248RHerr Laron · Bristol, SDBuilt 1975 · S/N TH-578 N7249YCt Capital LLC · Austin, TXS/N 30-274 N724BDEdelson David · New York, NYBuilt 1980 · S/N TJ-266 N724VSTwin Oaks L & A Ltd · Wilmington, DEBuilt 1957 · S/N 23-869 N72521Michigan Aeronautics Commission · Lansing, MIBuilt 1985 · S/N TH-1502 N7252YGuyer James · Billings, MTBuilt 1964 · S/N 30-277 N7253TPyro Shows Inc · La Follette, TNBuilt 1985 · S/N TH-1462 N7253YJednacz Scott T · Bixby, OKFirst renewal noticeBuilt 1964 · S/N 30-278 N7254PWildcat Ventures LLC · West Lebanon, NHBuilt 1985 · S/N TH-1504 N7254YSpldkd LLC · New Richmond, WIBuilt 1964 · S/N 30-280 N72553Whittom Ron W Jr · Wasilla, AKS/N 23-1031 N7255RZaviation LLC · Fort Smith, ARBuilt 1975 · S/N TH-572 N7257YRice Clark D · Anaconda, MTFirst renewal noticeBuilt 1964 · S/N 30-290 N7258BCff Of New Hampshire Inc · Madison, CTBuilt 1984 · S/N TH-1445 N7258YJprg Aviation Inc · Orlando, FLBuilt 1964 · S/N 30-291 N725HBReel Altitude LLC · Hahira, GABuilt 1996 · S/N TH-1776 N725LMSimply Living LLC · Fort Myers, FLBuilt 2002 · S/N 20800351 N725RWGalante Holdings LLC · Altamont, ILS/N 31-7952187 N7260YDeuce Aire LLC · Middletown, DEBuilt 1964 · S/N 30-294 N7261YKocak Robert G Jr · Peoria, AZBuilt 1964 · S/N 30-295 N7263YRag Wings And Radials Aircraft Leasing LLC · Georgetown, DEBuilt 1964 · S/N 30-298 N7264YYogi Air LLC · Wadsworth, OHBuilt 1964 · S/N 30-299 N726ASA2g International LLC · San Juan Capo, CABuilt 1975 · S/N 33701661 N726BADangerstik Corp · Olympic Valley, CABuilt 1979 · S/N TJ-214 N726LAValiair Lc Trustee · Casper, WYBuilt 1974 · S/N 421B0651 N726RTCrotts Aircraft Service Inc · Dodge City, KSBuilt 1976 · S/N 421C0087 N726TJJohnstone Thomas T · Panama City, FLBuilt 1976 · S/N TJ-80 N7272YToucan Aviation LLC · Bentonville, ARBuilt 1964 · S/N 30-311 N7273FB& G Air LLC · Hudson, FLBuilt 1976 · S/N 34-7770055

Back to AD 2004-25-16 R1