Registered aircraft · 8,471

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-14-12') 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-14-12') 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-14-12')
    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-14-12')
  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-14-12')
  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-14-12')
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.

N100EUSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2021 · S/N 28020030 N100HWYale Companies LLC · Fishers, INBuilt 2025 · S/N 2881884 N100JGClub Cherokee Inc · Crystal, MNBuilt 1988 · S/N 3213019 N100MSHam Aviation LLC · Marydel, DEBuilt 1977 · S/N 28-7890186 N100NAInternational Air Services Inc Trustee · Carson City, NVS/N 32R-8013093 N1019TAndrew University · Berrien Springs, MIBuilt 2006 · S/N 4496232 N101CEDurocher Alain P · Long Beach, CABuilt 1982 · S/N 32R-8229066 N101FMN101fm Inc Trustee · Wilmington, DES/N 3433153 N101HWYale Companies LLC DBA · Fishers, INBuilt 2025 · S/N 2881920 N101KWWiseman Ken L DBA · Calhoun, GABuilt 1980 · S/N 28-8016310 N101LLTribeca Aviation LLC · New York, NYBuilt 2000 · S/N 2843367 N101MLWesolowski Trevor · Berkeley, CABuilt 1981 · S/N 34-8233066 N101TKLensing Wayne K · Popular Grove, ILBuilt 1980 · S/N 32R-8029062 N101VPN101vp LLC · Ambler, PABuilt 1976 · S/N 28-7790131 N101WCole-Tac LLC · Rapid City, SDBuilt 1980 · S/N 32R-8013087 N1024QDuroc LLC · Watertown, WIBuilt 1977 · S/N 28-7790370 N1029HRegistration Pending · Bulverde, TXRegistration pendingS/N 28-7790278 N102DHPiper Aircraft Inc · Vero Beach, FLBuilt 2025 · S/N 4496597 N102EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2002 · S/N 2844081 N102PFKaehr Lyle · Decatur, INBuilt 1984 · S/N 28-8490042 N1030NDcaw Aviation LLC · Advance, NCBuilt 2006 · S/N 3246242 N1032GOsgood Air LLC · Hays, KSBuilt 2006 · S/N 4697285 N1032HPanhandle Air LLC · Destin, FLBuilt 2007 · S/N 4697302 N1036QKelley Michael · Bellingham, MABuilt 1977 · S/N 28-7716079 N103AVFlying To Infinity And Beyond LLC · Atlanta, GABuilt 1983 · S/N 28-8390084 N103ENKjs Development LLC · Temecula, CABuilt 1995 · S/N 4622186 N103SAHolman Steven R · Vero Beach, FLBuilt 1983 · S/N 28-8416012 N1040ZDonnelly Jeff E · Pembroke, MABuilt 2006 · S/N 3232062 N1041QSwaz Aviation LLC · Mesa, AZBuilt 1977 · S/N 28-7716081 N1043QRegistered aircraftBuilt 1977 · S/N 28R-7737025 N1045Paragon Airplane Leasing Co · Fort Myers, FLBuilt 2024 · S/N 28020177 N1047MChristiansen Aviation LLC · Wilmington, DEBuilt 2007 · S/N 2842286 N104AAMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881573 N104DHPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 2881999 N104EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2007 · S/N 2844135 N104FGWilson Conrad · Bowdon Junction, GAS/N 28-7716292 N104VADulles Aviation Inc · Bristow, VABuilt 2001 · S/N 2842115 N104WHGreycal Enteprrises Inc · Lake Mary, FLBuilt 2005 · S/N 3232046 N104WTFour Whiskey Tango LLC · Grosse Pointe Park, MIBuilt 2004 · S/N 3449301 N10586Cloud #9 Enterprises Inc · Mooresburg, TNS/N 4636404 N1059FRandag William F Jr · El Paso, TXS/N 2843643 N105AVAbbey Air Corp · New Castle, PABuilt 1983 · S/N 28-8490012 N105DGFraser And Daughter LLC · Saint Augustine, FLBuilt 2024 · S/N 4636857 N105DJDelta Juliet Holco I LLC · Ocoee, FLBuilt 2025 · S/N 2881910 N105HPRyan Transportation Services Ltd · Marysville, OHBuilt 2003 · S/N 3257322 N105HWYale Companies LLC DBA · Fishers, INBuilt 2026 · S/N 2881996 N1061TPlumbers Air Supply LLC · Overland Park, KSBuilt 2006 · S/N 4697274 N1063CJim Johnson Nissan Inc · Bowling Green, KYBuilt 2006 · S/N 3257440 N1063LWjm Aviation LLC · North Wales, PABuilt 2006 · S/N 2843644 N1064SSterling Smkr3 LLC · Oklahoma City, OKBuilt 2007 · S/N 4636411

Back to AD 2004-14-12