Registered aircraft · 671

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:2001-02-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-02-13') 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:2001-02-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-02-13')
  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:2001-02-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-02-13')
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.

N514JAAb Southwest Properties LLC · O Fallon, MOBuilt 2014 · S/N 525-0859 N516KMPico Cellular Communications Inc · Key Largo, FLBuilt 2015 · S/N 525-0868 N518RCBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 525-0516 N51CFive One Charlie LLC · Fayetteville, ARBuilt 2000 · S/N 525-0400 N51GNPowell Construction Company Inc · Johnson City, TNBuilt 1999 · S/N 525-0317 N520DFPar Avion LLC · Ketchum, IDBuilt 1996 · S/N 525-0154 N521AAOne Alpha Alpha LLC · Oakland, CABuilt 2016 · S/N 525-0920 N521PFAlton Blakley Aviation Inc · Somerset, KYBuilt 1993 · S/N 525-0005 N521ZBVivre Investments LLC · Weslaco, TXBuilt 2019 · S/N 525-1031 N522AJAj Capital Holdings LLC · The Woodlands, TXBuilt 1994 · S/N 525-0068 N522GLGreat Lakes Aviation LLC · Akron, OHBuilt 2010 · S/N 525-0697 N522KLClearview Investments LLC · Lexington, TNBuilt 2016 · S/N 525-0939 N522WPM & M Aviation LLC · Lincoln, NEBuilt 2016 · S/N 525-0924 N524TFBgmg LLC · San Antonio, TXBuilt 2022 · S/N 525-1136 N5255BWest Wind Air LLC · Lake Village, ARBuilt 1997 · S/N 525-0231 N525AQM2ntt LLC · Houston, TXBuilt 2024 · S/N 525-1164 N525AWD And D Aviation LLC · Tahoe City, CABuilt 2000 · S/N 525-0369 N525BDN300bb LLC · Melbourne Beach, FLBuilt 2026 · S/N 525-1407 N525BPPmi Aviation LLC · Fishers, INBuilt 2002 · S/N 525-0479 N525BRDk Aviation LLC · Pittsford, NYBuilt 2001 · S/N 525-0444 N525BTWhiting Wings LLC · Alexander, ARBuilt 1996 · S/N 525-0161 N525BWRegistered aircraftBuilt 2000 · S/N 525-0409 N525CJettech Holdings LLC · Broomfield, COBuilt 1999 · S/N 525-0332 N525CDLincoln Transport D LLC · Newark, DEBuilt 2000 · S/N 525-0360 N525CHRebus II LLC · Owasso, OKBuilt 1994 · S/N 525-0078 N525CMD Bar K LLC · Gatesville, TXBuilt 1995 · S/N 525-0093 N525CPAdios Aviation LLC · Austin, TXBuilt 1997 · S/N 525-0228 N525CXCentrex Construction Inc · Tigard, ORBuilt 2011 · S/N 525-0700 N525DCMalmstrom White Co · Little Rock, ARBuilt 1997 · S/N 525-0195 N525DPElk Factoring LLC DBA · Staunton, VABuilt 1999 · S/N 525-0318 N525DTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1994 · S/N 5250062 N525DUFtc Air Holdings 2 LLC · Tampa, FLBuilt 1997 · S/N 525-0205 N525EBellevue Advisors LLC · San Mateo, CABuilt 2014 · S/N 525-0853 N525FCExponential Thinking LLC · Houston, TXBuilt 2004 · S/N 525-0531 N525FNMci Air LLC · Dover, DEBuilt 2000 · S/N 525-0368 N525GCSav Aviation LLC · Jacksonville, TXBuilt 1994 · S/N 5250065 N525GEKek Companies Inc · Portland, ORFirst renewal noticeBuilt 2008 · S/N 525-0679 N525GKG Money LLC · Delavan, WIBuilt 1994 · S/N 525-0052 N525GLSk872 LLC · Wilmington, DES/N 525-0872 N525HCAircraft Trustee Services Inc Trustee · Dover, DEBuilt 1998 · S/N 525-0270 N525HLBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 525-0808 N525HMRegistered aircraftBuilt 2006 · S/N 525-0621 N525HQN525hq Aircraft Holdings LLC · Mount Pleasant, SCBuilt 2014 · S/N 525-0827 N525HSKen Dunbar & Sons Inc · Bakersfield, CABuilt 1993 · S/N 525-0035 N525HXValiair Lc Trustee · Casper, WYBuilt 1998 · S/N 525-0278 N525HYGp Farms LLC · Missoula, MTBuilt 1998 · S/N 525-0239 N525JCj525j LLC · Millersburg, OHBuilt 1997 · S/N 525-0184 N525JDCuprum Aviation LLC · Wellington, FLBuilt 2014 · S/N 525-0819 N525JESimply Living LLC · Fort Myers, FLBuilt 2002 · S/N 525-0493 N525JJReb Transporation LLC · Hattiesburg, MSBuilt 2002 · S/N 525-0497

Back to AD 2001-02-13