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.

N50CCScott Macdonald Aircraft Sales Inc · Stuart, FLBuilt 1974 · S/N 27-7405360 N50CSBoretsky Bryan F · Lolo, MTBuilt 1961 · S/N 23-1973 N50DLSand Castle Management LLC · Wichita, KSBuilt 1973 · S/N 421B0526 N50GBOviedo Juan M III · Oak Point, TXBuilt 1975 · S/N 340-0163 N50GTThomas Richard E · Lafayette, TNBuilt 1964 · S/N 310I0095 N50HGBethune David Scott · Stockton, CABuilt 1979 · S/N TJ-217 N50LWildcat Aeroplanes LLC · Sedalia, COBuilt 1977 · S/N 421C0431 N50MAGoodhue David H · Vancouver, WABuilt 1979 · S/N 414A0434 N50PSExecutive Airshares LLC · St Thomas, VIBuilt 1973 · S/N 31-7405165 N50RNOn Three Angels Wings LLC · Melbourne, FLBuilt 1983 · S/N 31P-8414013 N50SBCobb Susie O · Fayetteville, TNBuilt 1978 · S/N TC-2134 N50SSAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2000 · S/N TH-1961 N50TDPa-30 LLC · Appleton, WIBuilt 1965 · S/N 30-827 N50ZMAmerican Air Academy Inc · Merritt Island, FLBuilt 1980 · S/N 348070168 N50ZPPalen Mark T Trustee · Cleveland, TNBuilt 1975 · S/N 421C0022 N5102YK F Aviation Inc · San Juan, PRBuilt 1962 · S/N 27-2127 N510ADDj Aztec LLC · Springfield, OHBuilt 1980 · S/N 27-8054044 N510DYoungs Water Conditioning Of Logansport LLC · Logansport, INS/N 27-7654024 N510GCSchramm Craig O · Fenton, MIBuilt 1964 · S/N 27-2681 N510PChaos Holbrook Aviation LLC · Norman, OKBuilt 1979 · S/N 34-7970268 N510SMGolden Leaf Tobacco Company Inc · Keysville, VAS/N 421C0112 N510TFLang Eric O · Oklahoma City, OKBuilt 1978 · S/N 340A0499 N510UBoard Of Regents University Of Oklahoma · Norman, OKBuilt 2024 · S/N 4496588 N510VParkes Craig · White Salmon, WAS/N 310L-0113 N510WHCerniglia Paul J · Monroe Township, NJBuilt 1963 · S/N 310H0142 N51157Air Travel Management LLC · Lemont Furnace, PABuilt 1979 · S/N 34-7970392 N5116MBend Aircraft Mechanics LLC · Bend, ORBuilt 1978 · S/N ME-39 N511CFFendler Michael J · Pittsfield, MEBuilt 1977 · S/N TH-833 N511DFKma Aviation LLC · Phoenix, AZBuilt 1980 · S/N TH-1175 N511FClarke Kenneth J · Anchorage, AKBuilt 1963 · S/N TC-555 N511PJNanavati Parashar Jayendra Trustee · Springfield, ILBuilt 1983 · S/N 31T-1104006 N511VMRadler Glenn · Livingston, NJBuilt 1964 · S/N TC-785 N5120RKrause Aviation LLC · Geneva, ILS/N TC-1816 N5125YTassopoulos Thomas · Flushing, NYBuilt 1962 · S/N 27-2158 N512HPN512hp LLC · Dover, DEBuilt 1974 · S/N 340-0324 N512KZotec Partners LLC · Carmel, INBuilt 1978 · S/N 414A0054 N512SLSalmon Raymond A Trustee · Tavares, FLBuilt 1984 · S/N TJ-472 N513International Air Services Inc Trustee · Carson City, NVBuilt 1973 · S/N 33701572 N5134CEzrydr LLC · Huntsville, ALBuilt 1982 · S/N 414A0852 N513DWright Aero Inc · Saint Cloud, MNBuilt 1976 · S/N 340A0048 N513FSJackson Construction Services LLC · Wichita Falls, TXS/N 421C0510 N513JNFly Area LLC · Charleston, SCS/N 421C0293 N513SJWagner Distributing Co Inc · Auburn, CABuilt 1975 · S/N 421C0043 N5140JTruk Err Inc · Wilmington, DEBuilt 1975 · S/N 340-0530 N514BCCarlton Bradford Robert · Cape Coral, FLS/N 3449308 N514CGFlight Training Aircraft LLC · Wilmington, DEBuilt 2004 · S/N 4496187 N514ESBolufe Capital LLC · Miami, FLBuilt 2007 · S/N 3449349 N514JBSchneider Stephen C · Denton, TXBuilt 1969 · S/N TC-1263 N514LPInvader Aviation LLC · Tijeras, NMBuilt 1980 · S/N 414A0507 N5151JHalverson Mechanical Inc · Ogden, UTBuilt 1975 · S/N 340-0541

Back to AD 2004-25-16 R1