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.

N1MFNvision LLC · Frisco, TXS/N TH-835 N1MQGc4 Aero LLC · Birmingham, ALBuilt 1976 · S/N TH-731 N1NTDmac Aircraft LLC · Savannah, GABuilt 1964 · S/N 30-262 N1QMAhlhorn Travis W · New Braunfels, TXBuilt 1979 · S/N 421C0701 N1SRRensberger Scott C · Lake Jackson, TXBuilt 1962 · S/N 27-2050 N1SYPacific Fleet Aviation LLC · Rochester, NYS/N 27-7654186 N1WUN1wu LLC · Loganville, GABuilt 1966 · S/N 30-1383 N1YASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1974 · S/N 421B0580 N20059Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2026 · S/N 20800727 N2007EWallbirds LLC · San Diego, CABuilt 1978 · S/N ME-60 N2007KExecutive Flight Institute LLC · Murrieta, CABuilt 1978 · S/N ME-55 N2007P2007 Papa LLC · Fayetteville, GABuilt 1956 · S/N 23-579 N2007UBank Of Utah Trustee · Salt Lake City, UTBuilt 2026 · S/N 20800725 N2008ESchrott Bradley S · Federal Way, WABuilt 1978 · S/N ME-73 N2009EAce Of Spades Aviation LLC · Las Vegas, NVS/N ME-61 N2009XGriffith Aviation Inc · Griffith, INBuilt 1978 · S/N ME-66 N2009YFancy Pants Aviation LLC · Fort Worth, TXBuilt 1978 · S/N ME-74 N200BJWright Thomas L · Clyde, OHBuilt 1975 · S/N 33701684 N200BNRubber Duck Aviation LLC · Brunswick, GABuilt 1980 · S/N 421C0881 N200CBWarburton Patrick · Santa Rosa Valley, CABuilt 1973 · S/N TC-1517 N200CXPotter Aviation LLC · Milford, NJBuilt 1984 · S/N 31P-8414042 N200DCBjg Aviation I LLC · Neelyville, MOBuilt 1981 · S/N 421C1223 N200DFLijack World Enterprises LLC · Winter Haven, FLS/N 27-4080 N200GCDancy Abram P · Shrewsbury, MABuilt 1978 · S/N 340A0503 N200LFAeromarine Holdings LLC · Waukesha, WIBuilt 1989 · S/N 20800149 N200MCN200mc Inc Trustee · Cheyenne, WYBuilt 1973 · S/N 414-0424 N200P10x Aviation Partners LLC · Stuart, FLBuilt 1980 · S/N 31-8052124 N200PGPanther Enterprises LLC · Fort Myers, FLBuilt 1979 · S/N 31T-7920015 N200PVPrestwick Chase Inc · Saratoga Springs, NYBuilt 1971 · S/N 31P-64 N200RARagan William W · North Kansas City, MOBuilt 1974 · S/N 31P7400198 N200RTRiley Nolan C · Lubbock, TXS/N TK-101 N200SBSoaring Hawk Aviation LLC · Dexter, MIBuilt 1978 · S/N 34-7870399 N200SJChanney Aviation Group LLC · Las Vegas, NVBuilt 1981 · S/N 318152054 N200TNI & V Aviation LLC · Missoula, MTBuilt 1978 · S/N 421C0444 N200TSSmith Ironworks Of Alabama LLC · Fort Payne, ALBuilt 1978 · S/N 31T-7804002 N200WSSierra Juliet Nm LLC · Santa Teresa, NMBuilt 1974 · S/N 34-7450117 N200XLCondor Aviation LLC · Bethlehem, PABuilt 1981 · S/N 31T-8166010 N200YCShady Aero LLC · Anchorage, KYS/N 340A0285 N20125New Horizon Aviation Inc · Warwick, RIBuilt 1978 · S/N ME-94 N20148Baron 1-4-8 LLC · Merrimack, NHS/N TC-2159 N20162Wateractive43 LLC · Auburn, CABuilt 1974 · S/N 310Q-1004 N2016CRavey Guy W · Virginia Beach, VABuilt 1978 · S/N TC-2175 N2016KAlp Paul · Falls Church, VABuilt 1978 · S/N TC-2163 N2018LKrielow Law Firm LLC · Thibodaux, LABuilt 1978 · S/N TK-80 N2018PHauer Clifford Joseph Jr · Woodstock, GABuilt 1956 · S/N 23-590 N201DRegistered aircraftS/N TK-24 N201NKHelms John Broward II · Bartow, FLBuilt 1972 · S/N 27-4816 N2021UAll Airline Pilot Training LLC · Delray Beach, FLBuilt 1978 · S/N TH-957 N2022TAero-Marine LLC · Miramar Beach, FLBuilt 1978 · S/N TH-950 N2023ASouthern Cast Products Inc · Meridian, MSBuilt 1978 · S/N TC-2168

Back to AD 2004-25-16 R1