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.

N17TBarney Julius C · Lutz, FLBuilt 1968 · S/N 337-0990 N17UAce Flight LLC · Houma, LABuilt 1964 · S/N 310I0093 N17WEMckinney Joe M · Tuscumbia, ALBuilt 1978 · S/N 27-7854118 N17WPNorthern Indiana Twin LLC · Valparaiso, INBuilt 1964 · S/N TC-578 N1801LKeenan Brian M · Albuquerque, NMBuilt 1976 · S/N TC-1954 N1805WAero Equities LLC · Ventura, CABuilt 1972 · S/N TC-1505 N1806DGold Coast Logistics LLC · St Simons Island, GABuilt 1981 · S/N TJ-364 N1806WN1806w LLC · Show Low, AZS/N TC-1506 N1807NDouble Barrel Aviation LLC · Fort Valley, GABuilt 1981 · S/N TH-1263 N18087Small Mountain Flyers LLC · West Monroe, LAS/N ME-415 N1808RFlorida Fence Corp · Tavernier, FLS/N TJ-366 N1808WSailaway Management Inc · Wilmington, DEBuilt 1973 · S/N P-215 N1809MSkymaster-173 LLC · New Bern, NCBuilt 1971 · S/N 33701409 N180EPPiper Aircraft Inc · Vero Beach, FLS/N 4496656 N1810XAviation Trust Company LLC Trustee · Oklahoma City, OKS/N TH1266 N18142Aviation Trust Co LLC · Oklahoma City, OKBuilt 1981 · S/N TH-1270 N1814CSun Desert Enterprises · Spicewood, TXBuilt 1981 · S/N TC-2365 N1815LEagles Rise Aviation LLC · Wales, MAS/N TJ-63 N1815MReim Rodney D · Enid, OKBuilt 1971 · S/N 33701415 N1817SClear Skies LLC · Stuart, FLBuilt 1981 · S/N TH-1271 N1817ZOrr Lynn E · Fredericksburg, OHBuilt 1981 · S/N TJ-386 N18190Miller Chad A · Many, LAS/N TC-2403 N181DCAlliance Air Parts Acquisitions Corp · Oklahoma City, OKNon-citizen corporation, flight hours not reportedS/N 31T-7520026 N181FMLuse Otis · Lago Vista, TXS/N 34-7770400 N181JRCavu Clearing LLC · Palm Coast, FLBuilt 1982 · S/N TJ-363 N1821WModern & Classic Aviation LLC · North Royalton, OHBuilt 1973 · S/N TC-1522 N1822SSnider Nancy J · Washington, DCBuilt 1981 · S/N TC-2357 N1823WMuhler Wayne · Brighton, COS/N TC-1509 N1824MHeinke Nils A · Elkins, WVBuilt 1971 · S/N 33701424 N18269International Aviation Group LLC · Lake Wales, FLBuilt 1959 · S/N 23-1705 N1826WOzark Mountain Airways LLC · Springfield, MOBuilt 1973 · S/N TC-1510 N18273Hussey Mathias C · Frisco, TXBuilt 1977 · S/N TC-2065 N1827LCone James R Jr · Lubbock, TXS/N TH-741 N18280Team Holdings Inc · Sheridan, WYBuilt 1977 · S/N TJ-112 N18296Star Flight Aviation Inc · Shreveport, LABuilt 1977 · S/N TH-844 N1829ECorporate Airtime LLC · Clinton, MSBuilt 1981 · S/N TH-1282 N1830BLeading Edge Leasing LLC · Wilmington, DEBuilt 1981 · S/N TC-2410 N1830ZJaju Aviation Inc · Abilene, TXBuilt 1981 · S/N TJ-379 N18320Cox Jack H Jr · Arlington, TXBuilt 1977 · S/N TH-849 N18351Iowa Great Lakes Flyers Ltd · Cheyenne, WYBuilt 1977 · S/N TH-855 N18354Rich Broke Entertainment LLC · Conyers, GABuilt 1977 · S/N TC-2077 N18357Williams Randall G · Edgewater, MDBuilt 1977 · S/N TC-2078 N18358Life Is A Beech LLC · Los Lunas, NMBuilt 1977 · S/N TH-814 N1835BUtermoehlen Rickey D · Grass Valley, CABuilt 1977 · S/N TC-2076 N18361Landvater Darryl V · Williston, VTBuilt 1981 · S/N TH-1290 N18364Goeken Peter C · Dakota Dunes, SDBuilt 1977 · S/N TH-854 N18373T Mitchell Holdings Inc · Binghamton, NYBuilt 1981 · S/N TC-2415 N18386Gamco Aviation LLC · Shreveport, LABuilt 1977 · S/N TH-856 N18387Rizzuti Robert T · Theodosia, MOBuilt 1977 · S/N TC-2080 N1838LGordon Martin A · South Amboy, NJS/N TC-2008

Back to AD 2004-25-16 R1