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.

N436FHTextron Aviation Inc · Wichita, KSS/N 525-1436 N43NWAirvest Partners LLC · New Bern, NCBuilt 2004 · S/N 525-0543 N440BVBig Sky 205 LLC · Benbrook, TXBuilt 1997 · S/N 5250199 N442HRHotel Romeo LLC · Nichols Hills, OKBuilt 2023 · S/N 525-1158 N443BCTothemoon LLC · Salt Lake City, UTBuilt 1997 · S/N 525-0189 N448LLValiair Lc Owner Trustee · Casper, WYBuilt 2007 · S/N 525-0651 N44CKMile High Carpet Rides LLC · Dover, DEBuilt 2000 · S/N 525-0401 N44JBAnb Asset Holdings LLC · Missoula, MTBuilt 2019 · S/N 525-1038 N44VSHornet Aviation LLC · Anaheim, CABuilt 2002 · S/N 525-0500 N451NGOne Amigo LLC · Raleigh, NCBuilt 2022 · S/N 525-1128 N454MAMarv Air LLC · Chattanooga, TNBuilt 1998 · S/N 525-0286 N460RMMustang Two LLC · Newport Beach, CABuilt 2016 · S/N 525-0926 N4648LAquarius Investments LLC · Veguita, NMBuilt 2025 · S/N 525-1199 N464BHPajarito Investments LLC · Salt Lake City, UTBuilt 2014 · S/N 525-0858 N465JKDodeca Resources Inc · Henderson, NVBuilt 2017 · S/N 525-0949 N4687KNova Aviation LLC · Kemah, TXBuilt 2025 · S/N 525-1185 N46EWLexington Turbo LLC · Southborough, MABuilt 2013 · S/N 525-0802 N46KKHuff Air LLC · Uvalde, TXBuilt 2018 · S/N 525-1013 N471MDCitation Management LLC · Pelham, ALBuilt 1995 · S/N 525-0122 N473DBTrans Air LLC · Helena, MTBuilt 1996 · S/N 525-0129 N479CJLima Alpha One LLC · Newark, DEBuilt 2005 · S/N 525-0556 N479MYMcclain Mcclain Mcclain Inc · Ridgeland, MSBuilt 1993 · S/N 525-0018 N479RAValiair Limited Company Trustee · Casper, WYBuilt 2024 · S/N 525-1175 N47BFBoxley Farrell Aviation LLC · Roanoke, VABuilt 2024 · S/N 525-1171 N47SHGc Aviation Investments LLC · Augusta, ARBuilt 1993 · S/N 525-0017 N482EAWichita State University · Wichita, KSS/N 525-0482 N484AGBuckhorn Draw LLC · San Angelo, TXBuilt 2014 · S/N 525-0833 N484JSouthern Airways LLC · Ridgeland, MSBuilt 1994 · S/N 525-0048 N484SERoberts Steve C · Richmond, TXBuilt 2007 · S/N 525-0657 N486CCFlint Transport LLC · Albany, GABuilt 1997 · S/N 525-0213 N487CBCottingham & Butler Insurance Services Inc · Dubuque, IABuilt 2015 · S/N 525-0878 N488SRHard Way LLC · Dover, DEBuilt 2002 · S/N 525-0488 N489CBAir Giant LLC · Watsonville, CABuilt 2002 · S/N 525-0489 N489HCJ C Cheek Contractors Inc · Kosciusko, MSFirst renewal noticeBuilt 2001 · S/N 525-0437 N48DRRonald L Anderson LLC · Amery, WIBuilt 1998 · S/N 525-0272 N49JHWildhorse 340 LLC · Kalispell, MTBuilt 2017 · S/N 525-0959 N49NTCheyenne Aircraft LLC · Searcy, ARBuilt 2024 · S/N 525-1170 N501AKDl Fly LLC · Santa Maria, CABuilt 2009 · S/N 525-0689 N501CJOstrich Boot LLC · Little Rock, ARBuilt 1999 · S/N 525-0355 N504PWide Open Management Services LLC · Winston Salem, NCBuilt 1993 · S/N 525-0026 N504WFTito Enterprises LLC · Cameron, MTBuilt 2022 · S/N 525-1118 N505SJMidje LLC · Humboldt, TNBuilt 1994 · S/N 525-0051 N507HPCj Capital Partners LLC · Mount Pleasant, SCBuilt 2000 · S/N 525-0395 N508WGJobs Lane Aviation LLC · Englewood Cliffs, NJBuilt 2018 · S/N 525-0982 N50MReese Dave A · Capistrano Beach, CABuilt 1993 · S/N 525-0031 N511ECMississippi Air Express LLC · Madison, MSBuilt 1993 · S/N 525-0013 N511TCBam Aviation Of New York LLC · Sanford, FLBuilt 1994 · S/N 525-0074 N513RV1551 Leasing LLC · Placida, FLBuilt 2003 · S/N 525-0513 N514CKKenvic Aviation LLC · De Armanville, ALBuilt 2021 · S/N 525-1096 N514DSLugo Jose E Jr · Donna, TXBuilt 1998 · S/N 525-0255

Back to AD 2001-02-13