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.

N561JTSquires Seneca LLC · Wilmington, DEBuilt 1999 · S/N 3449136 N56213Elite Florida Ac LLC · Titusville, FLBuilt 1973 · S/N 347350304 N5622YStephan Jesse A · Richmond, TXBuilt 1964 · S/N 27-2732 N5627KTaxman Aviation Training Inc · Port Orange, FLBuilt 1964 · S/N TC-614 N5629YTart John W · Fayetteville, NCBuilt 1964 · S/N 27-2741 N56307Cjs Envol LLC · Rowayton, CTBuilt 1973 · S/N 34-7350315 N5634QLegacy Aero LLC · Jonesboro, ARBuilt 1990 · S/N TH-1598 N56368Performance Aircraft Sales Inc · Lincoln, NES/N 34-7350322 N5636GTres Locos Gringos LLC · Lubbock, TXBuilt 1990 · S/N TH-1586 N56413Hupert Jason M · Grand Blanc, MIBuilt 1973 · S/N 34-7350329 N5643CAdvance LLC · Waterville, MES/N TH-1573 N5644YGantt William M · Port Orange, FLBuilt 1965 · S/N 27-2758 N5649YPotenza Austin · Phoenix, AZBuilt 1964 · S/N 27-2764 N564RRAlpha Romeo Aviation LLC · Newark, DEBuilt 1982 · S/N T30300136 N56529Jilek Peter A · River Falls, WIBuilt 1973 · S/N 34-7350346 N56540Schilling Aviation Services LLC · Salina, KSBuilt 1973 · S/N 34-7350347 N5655CRegistration Pending · Westford, MARegistration pendingBuilt 1980 · S/N 340A0969 N5656KTompkins Wyatt M · Pearland, TXBuilt 1964 · S/N TC-756 N565BTGsg Aviation LLC · Fort Lauderdale, FLBuilt 1980 · S/N 31-8052118 N565RBEastern Kentucky University · Richmond, KYBuilt 2012 · S/N 4496307 N56658American Aviation Inc · Brooksville, FLBuilt 1973 · S/N 34-7450019 N56676Paris Air Inc · Vero Beach, FLBuilt 1973 · S/N 34-7450020 N56686Paris Air Inc · Vero Beach, FLBuilt 1973 · S/N 34-7450021 N566AGarrett Flying Service Inc · Danbury, TXBuilt 1965 · S/N 320D0062 N566BSSand Farm Management Services LLC · Adel, IABuilt 1970 · S/N 39-56 N567Herr John Robert · Saint Petersburg, FLFirst renewal noticeBuilt 1972 · S/N 310Q0459 N56701Eros Aviation Ventures LLC · Oakland Park, FLS/N 34-7450023 N5671YShore Gerry · Inez, TXBuilt 1965 · S/N 27-2785 N56755Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1973 · S/N 34-7450029 N56782Avie Ation LLC · Suwanee, GABuilt 1973 · S/N 34-7450031 N567CWPlane Fun Inc Tr Trustee · Snellville, GAS/N 0076 N567ETMusick Aircraft Corp · Greenwood, MSBuilt 1975 · S/N TC-1866 N567FLRidgeline Assets LLC · Wilmington, DEBuilt 2026 · S/N 4496643 N567JL2fly-Safety LLC Trustee · Azle, TXBuilt 1974 · S/N TC-1718 N567TCRegistration Pending · Platteville, WIRegistration pending, pending cancellationBuilt 1970 · S/N 39-63 N567WAJasper Aviation Inc · Jasper, ALS/N 421C-0713 N5680CSea Spray Aviation LLC · New Smyrna Beach, FLBuilt 1978 · S/N 414A0218 N5683YCaribbean Flyer LLC · Kinshill, VIBuilt 1965 · S/N 27-2799 N5687VColescott Zachary A · Cleveland, TNBuilt 1977 · S/N 34-7770261 N5687YBrouse Dan T · Magnolia, TXBuilt 1965 · S/N 27-2805 N5688C5688c LLC · Glendale, AZBuilt 1978 · S/N 414A0221 N5688KRouw Bruce L · Leesburg, FLBuilt 1964 · S/N TC-765 N5688YYates Mary A · Haysi, VABuilt 1965 · S/N 27-2806 N568PBas Part Sales LLC · Greeley, COS/N TC-2162 N568TWWestray James H · Gainesville, GABuilt 1981 · S/N 340A1252 N5690CTailwinds Aircraft Holdings LLC · Harrisburg, NEBuilt 1979 · S/N 414A0222 N5690ZGold Aviation LLC · Greenville, SCBuilt 1990 · S/N TH-1594 N5693YAlligator Air Transport LLC · Fort Lauderdale, FLS/N 27-2813 N569JMInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N 414A0425 N569LGPacific Gas And Electric Company · Concord, CABuilt 2015 · S/N 20800569

Back to AD 2004-25-16 R1