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.

N95TKTalos Aviation Group LLC · Blackstone, VABuilt 1970 · S/N 27-4555 N95WHPage William R · Bermuda Dunes, CABuilt 1978 · S/N TK-86 N9602FDodson Intenrational Parts Inc · Rantoul, KSBuilt 1985 · S/N 20800103 N9603CJtp Aviation LLC · Little Canada, MNBuilt 1978 · S/N 34-7870201 N960DFAir Services International Leasing LLC · Fort Lauderdale, FLBuilt 1979 · S/N 414A0444 N960EMCowboy Up Aviation LLC · Fort Worth, TXBuilt 1974 · S/N 421B0881 N961PAThiel Bros Roofing Inc · Sidney, MTFirst renewal noticeBuilt 1975 · S/N 317652017 N961PEParis Air Inc · Vero Beach, FLS/N 34-7250197 N96342Aircraft & Aviation Professionals LLC · Coldwater, MIBuilt 1977 · S/N 31-7405205 N9635CAirmans Aviation Co Ltd · Fort Smith, ARBuilt 1983 · S/N T30300196 N9639FTimuuu Inc · Alden, NYBuilt 1987 · S/N 20800121 N963SGElephant Shoe Air LLC · Vienna, VABuilt 1984 · S/N TJ-452 N9641FSpeedstar Express LLC · Lake Elsinore, CABuilt 1987 · S/N 20800122 N9642FSouthern Airways Pacific LLC · Addison, TXBuilt 1987 · S/N 20800110 N964MMModular Aviation LLC · Saratoga Springs, UTBuilt 1978 · S/N 27-7854132 N9652FFive Two Foxtrot LLC · Ray, MIBuilt 1987 · S/N 20800113 N965BWIkarus Aviation LLC · Salt Lake City, UTBuilt 1979 · S/N TC-2286 N966AAGateway Of Sturgis LLC · Sturgis, MIBuilt 1978 · S/N 44-7995120 N966UBTex Ark Air Corp · Melissa, TXBuilt 1977 · S/N TJ-120 N9678CUfnn Aviation LLC · Lake Charles, LAS/N 34-7870208 N967EYJoy Ventures LLC · Helena, MTBuilt 1967 · S/N 30-1577 N967ROpen Sky Aviation LLC · Salem, ORBuilt 1959 · S/N 23-1776 N967VVolare USA Corp · Wilmington, DEFirst renewal noticeBuilt 1977 · S/N TH-851 N9680TK And K Recycling Inc · Fairbanks, AKBuilt 1970 · S/N 31689 N968TCBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 20800513 N968TXTexas Department Of Public Safety · Austin, TXBuilt 2024 · S/N 20800713 N9693ACavu LLC · Honolulu, HIBuilt 1991 · S/N TH-1627 N9697FWilderness Aircraft III LLC · Boise, IDBuilt 1988 · S/N 20800128 N9699HDamschroder Rex A · Fremont, OHS/N 337-0395 N969AVPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 4496644 N969DCHuntley David W · San Antonio, TXBuilt 1968 · S/N TC-1169 N969RAFox Valley Technical College · Oshkosh, WIBuilt 1980 · S/N ME-317 N969TCBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 20800532 N969WAMiloud Chadd K · Fort Worth, TXBuilt 1980 · S/N 348070112 N96BDRoberts Aircraft Inc · West Chicago, ILBuilt 1974 · S/N TH457 N96GBEagle Equity Inc · Valparaiso, INS/N TH-882 N96HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 1978 · S/N ME-30 N96JNPetz Leroy E Jr · Montverde, FLBuilt 1985 · S/N 39-91 N96MAGoldielochs Air LLC · Annapolis, MDS/N 31T-7804005 N96PGWood David L · Lubbock, TXBuilt 1977 · S/N 34-7770277 N96PTEidson Mark C · Weatherford, TXBuilt 1976 · S/N TJ-31 N96WEChase Aviation De LLC · Dover, DEBuilt 1996 · S/N TH-1782 N96WFBrockman Leland Jay · Horseshoe Bay, TXBuilt 1990 · S/N TH-1595 N970GCAurora Skies LLC · Fernandina Beach, FLBuilt 1981 · S/N TH-1313 N970PSKrech Greg Trustee · Huron, SDBuilt 1979 · S/N 31T-8020023 N971FTStrong John Michael · Clarksburg, WVBuilt 1956 · S/N 23-847 N971PASkywest Leasing Inc · St George, UTBuilt 1999 · S/N 4496031 N971PDSpyglass Aircraft LLC · Milford, CTBuilt 1997 · S/N TH-1808 N971RJSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1971 · S/N 39-111 N9720FUnited States Of America · Melbourne, FLBuilt 1989 · S/N 20800144

Back to AD 2004-25-16 R1