Registered aircraft · 670

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.

N100PFPony Express Aviation LLC · Miami Beach, FLBuilt 2000 · S/N 525-0390 N101GPBankruptcy Services LLC · Wilmington, DEBuilt 2025 · S/N 525-1402 N101JWKorndawg LLC · Johnstown, OHBuilt 2017 · S/N 525-0950 N101USky West Aviation Inc Trustee · Albuquerque, NMBuilt 2001 · S/N 525-0454 N1022GWelcome Grove LLC · West Sacramento, CABuilt 2017 · S/N 525-0974 N104LWSt Croix Acceptance Corp · Devils Lake, NDBuilt 2013 · S/N 525-0806 N106CJCitation 525 Inc · Eugene, ORBuilt 1993 · S/N 525-0006 N106MJAngstrom Aviation LLC · Southfield, MIBuilt 2015 · S/N 525-0897 N107JGGrundy Aviation LLC · Horsham, PABuilt 2019 · S/N 525-1020 N108HPTextron Aviation Inc · Wichita, KSS/N 525-1422 N1099Carolina View Aviation LLC · Greensboro, NCBuilt 2019 · S/N 525-1028 N10DQTextron Aviation Inc · Wichita, KSS/N 525-1426 N10MDMiss Blackwell Aviation LLC · Pawleys Island, SCBuilt 2017 · S/N 525-0967 N1111SStockbridge General Contracting Inc · Clovis, CABuilt 2022 · S/N 525-1111 N111GEBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 525-0661 N1127KHutter Charles G · Carson City, NVBuilt 1998 · S/N 525-0293 N1135KQualitair LLC Trustee · MichelstadtBuilt 2022 · S/N 525-1135 N116MLRegistration Pending · Coshocton, OHRegistration pendingBuilt 2017 · S/N 525-0952 N11LGLima Golf Investments LLC · Bigfork, MTBuilt 1994 · S/N 525-0066 N11WBMercier David · Whitefish, MTBuilt 2006 · S/N 525-0616 N1205Z198gb LLC · Asheboro, NCBuilt 2018 · S/N 525-0985 N121VMAlan Aviation LLC · Altadena, CAS/N 525-0314 N124BGAdvance Jets LLC · Cincinnati, OHBuilt 1999 · S/N 525-0345 N125DWMcis Aviation LLC · Wilmington, DEBuilt 2021 · S/N 525-1095 N127MJZacj LLC · Zanesville, OHBuilt 1998 · S/N 525-0266 N12GYValiair Limited Co Trustee · Casper, WYBuilt 2000 · S/N 525-0374 N12NSCbi Equipment LLC · Tualatin, ORS/N 525-1063 N12RLPumpkin Patch Aviation LLC · Kodak, TNBuilt 2026 · S/N 525-1409 N131PLPd Aero LLC · Oronogo, MOBuilt 1994 · S/N 525-0057 N1327JAbsolute Altitude LLC · Bellefontaine, OHBuilt 1993 · S/N 525-0009 N133GLHs Air LLC · Little Rock, ARBuilt 1993 · S/N 525-0001 N146MMJackdaw Inc Trustee · Wilmington, DEBuilt 1997 · S/N 5250226 N1482BClear Line Aviation LLC · St George, UTBuilt 2015 · S/N 525-0888 N152KVPlane House LLC · Indianapolis, INBuilt 1996 · S/N 525-0152 N155BWPoet Inc · Sioux Falls, SDBuilt 2018 · S/N 525-0988 N155CGBigees Air LLC · Sioux Falls, SDBuilt 1997 · S/N 525-0214 N156MLAir Miles LLC · River Falls, WIBuilt 1996 · S/N 525-0156 N15EDClearview Aviation Group LLC · Peachtree City, GABuilt 2015 · S/N 525-0855 N15WEFirstrike Aviation LLC · Tulsa, OKBuilt 2014 · S/N 525-0847 N16WBPacebook Aviation LLC · Albany, GABuilt 2016 · S/N 525-0905 N170MUCitationjet 525 LLC · Wilmington, DEBuilt 1996 · S/N 525-0170 N177VVDodson International Parts Inc · Rantoul, KSBuilt 1997 · S/N 525-0182 N17LJGenetech Animal Reproduction LLC · Purcell, OKBuilt 2000 · S/N 525-0372 N17VBN17vb LLC · Nacogdoches, TXBuilt 1997 · S/N 525-0206 N18466Pantaxios LLC · Spencerport, NYBuilt 2019 · S/N 525-1034 N1865CHotel Alpha LLC · Tampa, FLBuilt 2007 · S/N 525-0647 N186DLAesop LLC · Las Vegas, NVBuilt 2013 · S/N 525-0803 N186TWTnp Aviation LLC · Valdosta, GABuilt 2001 · S/N 525-0416 N187MCAe Aircraft LLC · Longview, TXBuilt 1998 · S/N 525-0276 N188SBHigh Flyers LLC · Hobbs, NMBuilt 2015 · S/N 525-0879

Back to AD 2001-02-13