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.

N901JWThunderbolt Transport Inc · Memphis, TNBuilt 2022 · S/N 525-1123 N903GWPro Water Solutions LLC · Henderson, TXBuilt 2008 · S/N 525-0676 N904GWCobb Industrial Inc · Holly Springs, GABuilt 2008 · S/N 525-0681 N905GSGlh Capital LLC · Pittsfield, MABuilt 2023 · S/N 525-1137 N905GWN905gw LLC · Lake Park, GABuilt 2008 · S/N 525-0682 N906RRHill Country Restaurants Inc · Nacogdoches, TXBuilt 2016 · S/N 525-0906 N906WGClbs Equipment LLC · Prosper, TXBuilt 2022 · S/N 525-1122 N907DKAbsolute Aviation LLC · Dayton, OHBuilt 1999 · S/N 525-0338 N907GWPnc Bank Na · Boise, IDBuilt 2018 · S/N 525-1011 N908GWJoe Morten & Son Inc · South Sioux City, NEBuilt 2023 · S/N 525-1140 N908PRCitation 908 LLC · Chattanooga, TNS/N 525-0148 N909DPCook Childrens Health Enterprises · Fort Worth, TXBuilt 2002 · S/N 525-0503 N909GWJoe Morten & Son Inc · South Sioux City, NEBuilt 2023 · S/N 525-1142 N909HTAmd-Kls LLC · Sevierville, TNBuilt 2000 · S/N 525-0382 N909MWilmington Trust Co Trustee · Wilmington, DEBuilt 1998 · S/N 525-0249 N909YR909 Aero LLC · Phoenix, AZBuilt 1999 · S/N 525-0339 N90DBDura-Built Of Delaware LLC · Lewes, DEBuilt 2018 · S/N 525-1005 N911QJean Burkholder And Glen Ellis LLC · Midland, TXBuilt 1997 · S/N 5250220 N913TDJwt Equipment LLC · Springdale, ARBuilt 2001 · S/N 525-0468 N915DHDsw Development Co · Cape Girardeau, MOBuilt 2015 · S/N 525-0881 N915SFLock Haven Aircraft Sales · Lewes, DEBuilt 1999 · S/N 525-0301 N917APDynamic Chemical Solutions Inc · Frisco, TXBuilt 2016 · S/N 525-0917 N917GWJoe Morten & Son Inc · South Sioux City, NEBuilt 2023 · S/N 525-1143 N918AMAmdel Holding LLC · Houston, TXBuilt 2003 · S/N 525-0508 N918BKSw El LLC · Palestine, TXBuilt 2001 · S/N 525-0419 N918LPNew Chat Air LLC · Chattanooga, TNBuilt 2020 · S/N 525-1058 N919MCHanson Operating Company Inc · Roswell, NMBuilt 2006 · S/N 525-0600 N91BBBunn Brothers Aviation LLC · Tuscaloosa, ALBuilt 2001 · S/N 525-0417 N91KKState Of Florida · Tampa, FLBuilt 2022 · S/N 525-1119 N91RBCitation Sky LLC · Moody, ALS/N 5250124 N921XTSundance Mc LLC · Dallas, TXBuilt 2015 · S/N 525-0877 N923TBCaffey Distributing Company Inc · Greensboro, NCBuilt 2024 · S/N 525-1166 N924XSchieffer Enterprises LLC · Kurten, TXBuilt 2015 · S/N 525-0865 N925JATrue North Aviation LLC · Harrisburg, SDBuilt 2017 · S/N 525-0963 N929JTDulcich Nick Prosper · Bakersfield, CABuilt 1993 · S/N 525-0011 N929MMOtm Equipment LLC · Westlake, TXBuilt 2009 · S/N 525-0692 N92SBLone Star Air LLC · Castle Rock, COBuilt 2022 · S/N 525-1106 N92WGDndd Capital Holdings LLC · Plano, TXBuilt 2015 · S/N 525-0871 N931SRIsr Aviation LLC · Wilmington, DES/N 525-0175 N931TNJude Aviation LLC · Clarksville, TNBuilt 2023 · S/N 525-1150 N933RGMsblt LLC · Hobe Sound, FLBuilt 2016 · S/N 525-0933 N934CWM2 Aviation LLC · Rockledge, FLBuilt 2016 · S/N 525-0934 N940SWBh Aero LLC · Birmingham, ALBuilt 1994 · S/N 5250071 N944JAircraft N944j LLC · Metairie, LABuilt 2017 · S/N 525-0944 N947HCHarrison Contracting Co Inc · Villa Rica, GABuilt 1994 · S/N 525-0077 N94ALBbj Ventures LLC · Goldsboro, NCBuilt 2001 · S/N 525-0432 N950PLlbb Air LLC · Amarillo, TXBuilt 1998 · S/N 525-0234 N955TXLouis Jean LLC · Andrews, TXBuilt 2000 · S/N 525-0386 N958MGMgi Air Inc · Dubuque, IABuilt 2013 · S/N 525-0805 N959HMJavelina Aviation LLC · Cheyenne, WYBuilt 1993 · S/N 525-0047

Back to AD 2001-02-13