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.

N26DTMdr Construction Inc · Columbia, MSBuilt 2013 · S/N 525-0814 N26RLJs Aircraft LLC · Eden, NCBuilt 1997 · S/N 525-0207 N278KThienes Engineering Inc · La Mirada, CABuilt 2003 · S/N 525-0527 N27CJ411kc LLC · Tuscaloosa, ALBuilt 1999 · S/N 525-0311 N27EWTextron Aviation Inc · Wichita, KSS/N 525-1425 N287CBCottingham & Butler Insurance Services Inc · Dubuque, IABuilt 2017 · S/N 525-0942 N28CKC Star Aviation LLC · Evansville, INBuilt 1997 · S/N 525-0210 N28FDPacific Air Center LLC · Long Beach, CABuilt 2014 · S/N 525-0822 N28QAHuff Air LLC · Uvalde, TXBuilt 1997 · S/N 5250215 N28RKRd Aviation Lp · Redlands, CABuilt 1995 · S/N 525-0111 N294CWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1995 · S/N 525-0114 N295DS4f Managment LLC · Salem, ORBuilt 1994 · S/N 525-0091 N295MLCorning Companies LLC · Billings, MTBuilt 2019 · S/N 525-1043 N2ZBCitizen Aero Inc Trustee · Sheridan, WYBuilt 2021 · S/N 525-1101 N300BVCj Bravo Victor LLC · Ridgeland, MSBuilt 2001 · S/N 525-0418 N300FCDresden Aviation LLC · Atlanta, GABuilt 1998 · S/N 525-0248 N303KMCoastal Rentals LLC · Allen, KYBuilt 2000 · S/N 525-0180 N304BPIntermountain Air Inc · Colorado Springs, COBuilt 2019 · S/N 525-1017 N308CMCattlemen Logistics LLC · Minden, NEBuilt 2023 · S/N 525-1156 N308NJ22ase LLC · Aspen, COS/N 525-0912 N30BPLkh Group LLC · Naples, FLBuilt 2014 · S/N 525-0816 N30KMRefreshed 0110 LLC · Dover, DEBuilt 2021 · S/N 525-1073 N30LAAerokb LLC · Wilmington, DEBuilt 1993 · S/N 5250041 N30MSkysouth Aviation Inc · Durham, NCBuilt 2003 · S/N 525-0506 N30NMTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 525-1420 N30NSHilltop LLC · Rye, NYBuilt 2014 · S/N 525-0835 N30VRWd Journeys Inc · Downers Grove, ILBuilt 2002 · S/N 5250481 N311CPKwihnai Flyers LLC · Troy, OHBuilt 2024 · S/N 525-1165 N311SRIsr Aviation LLC · Wilmington, DES/N 525-0172 N313WLPeak Aviation LLC · Royal Oak, MIBuilt 2000 · S/N 525-0366 N315HCHooper Holdings LLC · Madison, WIBuilt 2000 · S/N 525-0373 N3168N3168 LLC · San Antonio, TXBuilt 2026 · S/N 525-1405 N316PJWmj Aviation LLC · Wilmington, DEBuilt 2000 · S/N 525-0405 N318CGSvp LLC · Missoula, MTBuilt 1999 · S/N 525-0323 N318JHAir Hoffmann LLC · Saint Louis, MOBuilt 2014 · S/N 525-0817 N318JPSurric LLC · Shreveport, LABuilt 2024 · S/N 525-1174 N319JDHollingsworth Intergalactic LLC · Clinton, TNBuilt 1997 · S/N 5250216 N31CJ212 Investments Of Montana LLC · Collinsville, OKBuilt 2001 · S/N 525-0474 N31HAHampden Aviation Services Inc · Florence, MABuilt 2014 · S/N 525-0829 N31HDHotel Delta LLC · Sacramento, CABuilt 1998 · S/N 525-0261 N31SPBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2015 · S/N 525-0874 N31WEWorldwide Equipment Of Tn Inc · Knoxville, TNBuilt 2000 · S/N 5250362 N321EMRiomar Sky LLC · Warrington, PABuilt 2023 · S/N 525-1152 N321RRambarran Brian D · Clarence Center, NYBuilt 1994 · S/N 525-0049 N323EZN323ez LLC · Amarillo, TXBuilt 1996 · S/N 525-0128 N324BDGodwin Aviation LLC · Dunn, NCBuilt 2008 · S/N 525-0674 N326JKRiver Bank Aviation LLC · Dover, DEBuilt 2003 · S/N 525-0511 N328CJRegistration Pending · College Grove, TNRegistration pendingBuilt 1999 · S/N 525-0328 N32BBGee Aviation Inc · Sturgis, KYBuilt 2019 · S/N 525-1026 N331GGGed Jet LLC · Boca Raton, FLBuilt 1999 · S/N 525-0353

Back to AD 2001-02-13