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.

N90FSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1979 · S/N 31T-8020011 N90JFIsr Aviation LLC · Wilmington, DEBuilt 1985 · S/N 20800005 N90MKBs LLC · Huntsville, TXBuilt 1977 · S/N 421C0282 N90PAD&J Aviation LLC · Apopka, FLS/N 8207019 N90PVSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1968 · S/N 310N-0054 N90VMJ & B Leasing Inc · Springfield, MOBuilt 1981 · S/N 31T-8104031 N91045Dakota Aircraft Specialists LLC · Hot Springs, SDBuilt 1975 · S/N 414-0623 N91053Garvin Lee E · Brookings, ORS/N 340A1039 N910AGCreative Marketing Associates Inc · Saint Petersburg, FLBuilt 1984 · S/N 31T-8004041 N910FVip Aviation LLC · Sunrise, FLBuilt 1983 · S/N 34-8333088 N910HGTiffin Aire Inc · Tiffin, OHS/N 31T-7400009 N910JPRegistered aircraftBuilt 1977 · S/N 31T-7820004 N910KTAtp Aircraft 6 LLC · Wilmington, DEBuilt 2007 · S/N 4496246 N910SAPersistent Roots LLC · Carpentersville, ILBuilt 1999 · S/N TH-1910 N910TN910t LLC · Newark, OHBuilt 1970 · S/N TC-1361 N910WWLundell Plastics Corp · Odebolt, IABuilt 2004 · S/N TH-2092 N9110VSmith Stephen R · Lake City, FLBuilt 1969 · S/N 310P-0167 N91119Sky Ocean Group LLC · Lewes, DES/N 27-4121 N9114KSt Barth Rallye Inc Trustee · Wilmington, DEBuilt 1976 · S/N 34-7670188 N9119QPrestige Worldwide Aviation LLC · Kalispell, MTBuilt 1970 · S/N TC-1375 N911MAJohnson Jeffery V · Floydada, TXBuilt 1973 · S/N P-225 N911MFMissionary Flights & Service Inc · Fort Pierce, FLBuilt 1968 · S/N 310N-0080 N911RKBurnley Christopher · Henderson, NVS/N 30-1184 N911UT9sixteen Motorsports · Lusby, MDS/N TC-928 N9122SMercer Warren G · Bogart, GABuilt 1976 · S/N TC-1939 N91284Lee John · Marietta, OHBuilt 1979 · S/N 347970111 N912LLLegacy Air LLC · Cadillac, MIBuilt 1978 · S/N 34-7870020 N912PAlf Ix LLC · Chicago, ILS/N 30-951 N912SCCrest Five Associates Inc · Breinigsville, PABuilt 1991 · S/N TH-1646 N912WTNew Tech Construction LLC · Wilmington, DEBuilt 1977 · S/N 340A0353 N9134SDaytona Aircraft Services Inc · Daytona Beach, FLS/N TH-726 N9139KSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1976 · S/N 34-7670189 N913NCDeweese Michel J · Rockvale, TNBuilt 1981 · S/N 31T-8120044 N914ASRed Speakers LLC · Newark, DEBuilt 1981 · S/N 31T8104066 N914CCJ&W Racing And Aviation LLC · Port Saint Lucie, FLBuilt 1967 · S/N 27-3769 N915Ramsey Brent C · Tulsa, OKBuilt 1980 · S/N 340A0910 N915AZN915az LLC · Miami, FLBuilt 1974 · S/N 34-7450199 N915JFFox James R · St Paul, MNBuilt 1991 · S/N 20800209 N915LPLee Flight Services LLC · Davie, FLS/N 421B0572 N915TXKing Daniel · San Antonio, TXBuilt 1981 · S/N 34-8133258 N915VThomas Robert W · Henderson, NVFirst renewal noticeBuilt 1974 · S/N TC-1785 N9163NN2242z LLC · Newtown, CTS/N 3433139 N9164NDangberg Dennis · Wayne, NEBuilt 1964 · S/N TC-574 N9167YComanche Flyers Inc · Gig Harbor, WABuilt 1968 · S/N 31-220 N916DPGalliot Bond LLC · Atlanta, GAS/N 27-7654183 N916DSScout Aviation (De) LLC · Wilmington, DES/N 34-7970237 N916JWSouth Delta Aviation Inc · Fayetteville, ARBuilt 1976 · S/N TJ-91 N916MTSchumacher Charles · Cambridge, MABuilt 1973 · S/N TC-1623 N916RDUssery Donald R · Blytheville, ARS/N 23-1743 N916RTAasjng LLC · Holdrege, NEBuilt 1981 · S/N 31T-8166041

Back to AD 2004-25-16 R1