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.

N8128JPaul A Young Pa · North Little Rock, ARBuilt 1979 · S/N 34-8070036 N8129QJolly Tyler S · Grover, COS/N 414-0029 N812JCLfgsgb LLC · Greenville, SCBuilt 1992 · S/N TH-1676 N812SRVantage Point Northwest Aviation LLC · Sheridan, WYBuilt 1979 · S/N 414A0326 N812TBTwin Aviation LLC · Coushatta, LABuilt 1981 · S/N 31-8152113 N812VLa Plane LLC · Fort Thomas, AZBuilt 1972 · S/N 340-0157 N8131Regional Air & Transport LLC · Mims, FLBuilt 1981 · S/N 31-8152032 N8131EInfratech Corp · Kennesaw, GABuilt 1982 · S/N 34-8233093 N8131QClub Jet Investments LLC · Wilmington, DES/N 414-0031 N8132YJessen Eric Carl · La Luz, NMBuilt 1966 · S/N 30-1244 N8133QFinnan-Johnson Flying Club LLC · Woodinville, WABuilt 1972 · S/N 310Q0626 N8133YLeaders Bob O · Clear Lake, MNBuilt 1966 · S/N 30-1245 N8134KTory Hill Innovations LLC · Stillwater, MNBuilt 1979 · S/N 34-8070055 N8134QPaul Morrill Excavating Inc · Newcastle, CABuilt 1969 · S/N 414-0034 N8134SThwaites Dwayne · Elizabeth City, NCS/N 34-8070056 N8137YSale Reported · Chisago City, MNSale reportedBuilt 1966 · S/N 30-1248 N8139MAcme Racing LLC · Overland Park, KSBuilt 1964 · S/N 310I0139 N8139YBuchanan Jason A · Meridian, IDBuilt 1966 · S/N 30-1250 N813CNAtp Aircraft 7 LLC · Wilmington, DEBuilt 2008 · S/N 4496251 N8141MTerry Jan Chester · Beverly Hills, FLBuilt 1964 · S/N 310I0141 N8143YTennave LLC · Dublin, OHBuilt 1966 · S/N 30-1254 N8144QOcf Air LLC · Phoenix, AZBuilt 1970 · S/N 414-0044 N8145QWestern Nebraska Community College · Scottsbluff, NES/N 414-0045 N8145RWatch Ya Head Aviation I LLC · Zionsville, INBuilt 1974 · S/N TC-1743 N8147DHamic Lonny T DBA · Powell, WYBuilt 1979 · S/N 34-8070113 N8147ETouretzky David S · West Mifflin, PABuilt 1979 · S/N 34-8070114 N8147FHubble Timothy S · Lake Alfred, FLS/N 34-8070117 N8147MDe La Rosa Sergio · Nogales, AZBuilt 1964 · S/N 310I0147 N8147YRietz Douglas W · Walla Walla, WABuilt 1966 · S/N 30-1259 N814ATDot Aviation LLC · Wilmington, DEBuilt 2019 · S/N 4496493 N814CHAviator LLC · Saint Paul, MNBuilt 1982 · S/N 34-8233070 N814DBNorth Rock LLC · Wilmington, DEBuilt 1973 · S/N TC-1560 N814JAdvantage Aviation Services LLC · South Saint Paul, MNS/N 337-0596 N814RCCamelot Express LLC · Naples, FLBuilt 1966 · S/N 301202 N814SWWenman Bradford Harris · Johnson, KSS/N 340-0197 N814WT1st West Aviation Inc · Salt Lake City, UTBuilt 2014 · S/N 3449495 N8150QSouthern Journey LLC · South Padre Island, TXS/N 414-0050 N8150YBok Hans · North Dartmouth, MAFirst renewal noticeBuilt 1966 · S/N 30-1263 N81514Soar Above Flight Solutions LLC · Englewood, TNS/N 30-1264 N8151QMiller James A Md · Merino, COS/N 414-0051 N8151REnterprise Aviation Holdings LLC · Wilmington, DEBuilt 1974 · S/N TH-510 N8154JCarter Flygare Inc · Sacramento, CABuilt 1980 · S/N 44-8095020 N8154YRawson Aviation LLC · Collinsville, OKBuilt 1966 · S/N 30-1267 N8155RLarson James R · Waupaca, WIBuilt 1976 · S/N TC-1948 N8155YTalley John T · Clifton, TXS/N 30-1269 N8156KJrm Aviation LLC · Saint Petersburg, FLS/N 34-8070133 N8156QFitch Douglas A · Sheffield Village, OHBuilt 1980 · S/N 34-8070136 N8157YSchmidt Zachary P · Raleigh, NCBuilt 1966 · S/N 30-1270 N815ATSeminole Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 4496533 N815BFN815bf LLC · Westlake Village, CABuilt 1974 · S/N TC-1659

Back to AD 2004-25-16 R1