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.

N526MDBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 525-0604 N527MStevenson Leasing LLC · Kansas City, KSBuilt 2022 · S/N 525-1107 N527PTSatelite Industries Inc · Minneapolis, MNBuilt 2018 · S/N 525-0999 N5298XLawtx Travel LLC · Houston, TXBuilt 2001 · S/N 525-0440 N529FDDft LLC · Central Point, ORBuilt 1997 · S/N 525-0192 N529TATodhunter Aviation LLC · Wilmington, DEBuilt 2019 · S/N 525-1037 N52KXZb Air LLC · Broken Arrow, OKBuilt 1998 · S/N 525-0287 N52ZGLift Aviation LLC · Aspen, COBuilt 2015 · S/N 525-0891 N531BROvation Of Columbia LLC · Augusta, GAS/N 525-0264 N535Citation Jet 535 LLC · Moultrie, GABuilt 2001 · S/N 525-0445 N53KVBank Of Utah Trustee · Salt Lake City, UTBuilt 1993 · S/N 525-0030 N540JLBank Of Utah Trustee · Salt Lake City, UTBuilt 2023 · S/N 525-1138 N540WCFirst State Bancshares Inc · Farmington, MOBuilt 2025 · S/N 525-1187 N545JSSuperus Capital Partners LLC · Memphis, TNBuilt 2003 · S/N 525-0524 N545LSBlue Earth Cellular LLC · Blue Earth, MNBuilt 2014 · S/N 525-0840 N545RWNegative Contact LLC · Albuquerque, NMBuilt 1996 · S/N 525-0141 N545TGStarr Mountain Aviation LLC · Athens, TNBuilt 2004 · S/N 525-0545 N54CYExtollo Aviation Partners LLC · Denver, COBuilt 2017 · S/N 525-0953 N54DAThoroughbred II LLC · State College, PABuilt 2001 · S/N 525-0470 N54HCThree Bears Aviation LLC · Prineville, ORBuilt 1996 · S/N 525-0157 N54MZFinch John Lambeth · Greensboro, NCBuilt 2023 · S/N 525-1154 N551FPSkyway Aviation Services Inc · Palm Harbor, FLBuilt 2003 · S/N 525-0515 N555BGN & E Aviation LLC · Olathe, COS/N 525-0113 N557HPBlues City Aviation LLC · Germantown, TNBuilt 2008 · S/N 525-0668 N558WGMom2 Advisors LLC · Wilmington, DEBuilt 2018 · S/N 525-1008 N55CJN55cj LLC · Modesto, CABuilt 1998 · S/N 525-0298 N55JPDakota Aircraft Inc · Pierre, SDBuilt 1998 · S/N 525-0296 N55SKSierrakilo LLC Trustee · Fort Lauderdale, FLBuilt 1994 · S/N 525-0063 N55VHCombined Aircraft Ownership LLC · Fargo, NDBuilt 2022 · S/N 525-1120 N561BCInternational Bank Of Commerce · Laredo, TXBuilt 1998 · S/N 525-0257 N562PCDelta Farm Express LLC · Richview, ILBuilt 1996 · S/N 525-0151 N563DDTextron Aviation Inc · Wichita, KSS/N 525-1428 N567BWDac Air LLC · Lakewood Ranch, FLBuilt 2018 · S/N 525-0983 N56XPEverair LLC · Niagara Falls, NYBuilt 2016 · S/N 525-0904 N570CJJe Consulting LLC · Geneseo, ILBuilt 2020 · S/N 525-1051 N570DMAb Monterrey Aircraft LLC · San Antonio, TXBuilt 1994 · S/N 525-0055 N571GTConrad Aviation LLC · Forest Hill, LABuilt 2021 · S/N 525-1089 N572RSB2b Aviation LLC · Leesburg, VABuilt 2026 · S/N 525-1421 N573CMFlightline Holdings LLC · New Orelans, LABuilt 1999 · S/N 525-0352 N574TATango Alpha Management Co LLC · Georgetown, SCBuilt 2026 · S/N 525-1406 N575TMHauck Enterprises Ltd · Port Neches, TXBuilt 2014 · S/N 525-0838 N577KPPelican Sky LLC · Abbeville, LABuilt 2000 · S/N 525-0389 N578CFInfinity Aviation LLC · Mandan, NDBuilt 2017 · S/N 525-0965 N579TXLaw Offices Of Douglas D Ketterman Pllc · San Antonio, TXBuilt 1994 · S/N 525-0061 N57ECSaratoga Homes Of Texas San Antonio LLC · El Paso, TXBuilt 2001 · S/N 525-0460 N57VYEuroaviation Inc Trustee · KematenS/N 525-0371 N580BDAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1997 · S/N 525-0209 N580ZTaft Enterprises LLC · Wilmington, DEBuilt 2008 · S/N 525-0672 N585MCStuart Nathan · Saint Augustine, FLS/N 525-0452 N585MLBh Transportation LLC · Jackson, TNBuilt 2000 · S/N 525-0402

Back to AD 2001-02-13