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.

N194MGSdw Aviation LLC · Albany, GABuilt 1999 · S/N 525-0357 N1957NAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2024 · S/N 525-1182 N195MFHat*Trick Holdings LLC · Buchanan, MIBuilt 1995 · S/N 525-0110 N19DPMonterey Bay LLC · Atlanta, GABuilt 1993 · S/N 525-0040 N19RCTequila Flights LLC · Maple Grove, MNBuilt 2016 · S/N 525-0919 N1BZL2 Operations LLC · Saint Paul, MNBuilt 2001 · S/N 525-0439 N1FMCokelet LLC · South Padre Island, TXBuilt 1997 · S/N 525-0218 N200SLAtfo LLC · Wildwood, MOBuilt 2001 · S/N 525-0461 N204JCentral Beach LLC · El Paso, TXBuilt 1996 · S/N 525-0164 N205TCCarpenter Aviation LLC · Northport, ALBuilt 1994 · S/N 525-0050 N20DCKar Aviation LLC · New Albany, MSS/N 5250208 N20VLRusken Packaging Inc · Cullman, ALBuilt 1994 · S/N 525-0069 N210MBSafe Flight LLC · Suwanee, GABuilt 1997 · S/N 525-0211 N212RHCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 525-0636 N213JTLake Air Sale LLC · Wilmington, DEBuilt 2002 · S/N 525-0492 N219HFAugusta Air II LLC · Fayetteville, NCBuilt 2016 · S/N 525-0907 N21TKMtk Leasing LLC · Woodburn, ORS/N 525-0131 N21VCCitation Hawk LLC · Moody, ALBuilt 1995 · S/N 525-0106 N220JLJuliet Charlie LLC · Wolf Creek, MTS/N 525-0020 N222JMOld Well Aviation LLC · Charlotte, NCBuilt 1995 · S/N 525-0116 N222TCCase Coal Sales LLC · Louisa, KYBuilt 2017 · S/N 525-0960 N223CFCbel Aviation Inc · Macon, GABuilt 2000 · S/N 525-0403 N223JFJettair LLC · Dallas, TXBuilt 1997 · S/N 525-0223 N224CJEagle Aviation LLC · Hamel, MNBuilt 1997 · S/N 525-0224 N22SDodson International Parts Inc · Rantoul, KSBuilt 2014 · S/N 525-0842 N232BWNoram Aviation LLC · Tulsa, OKBuilt 2022 · S/N 525-1109 N23BKBig Sky Leasing LLC · Madison, WIBuilt 1997 · S/N 525-0198 N23YTVision X LLC · Chattanooga, TNBuilt 2026 · S/N 525-1408 N242BSDm Aviation LLC · Lexington, SCBuilt 1997 · S/N 525-0230 N242LMHeritage Logistics LLC · Holdrege, NEBuilt 2017 · S/N 525-0970 N242PGPage Aviation LLC · Saint Louis, MOBuilt 2018 · S/N 525-0993 N242RFOwsley Robert L · Anchorage, AKBuilt 1998 · S/N 525-0294 N242SDBinette Alan · Medford, ORBuilt 2020 · S/N 525-1069 N246ESFlight Services Inc · St Thomas, VIBuilt 2023 · S/N 525-1161 N246GLBonanza Management LLC · Newark, DEBuilt 2001 · S/N 525-0446 N249CALafayette Flight Service LLC · Broussard, LABuilt 1998 · S/N 525-0291 N24XPOlive Organization LLC · El Paso, TXBuilt 2019 · S/N 525-1023 N251GMJrjgc Investments LLC · Saltillo, MSBuilt 2015 · S/N 525-0895 N252JKLow Country 525 LLC · Charleston, SCBuilt 1996 · S/N 525-0166 N252RVHssj LLC · Chattanooga, TNBuilt 1998 · S/N 5250252 N253CWRegistered aircraftBuilt 1998 · S/N 525-0253 N256JBBlossman Gas Of North Carolina Inc · Swannanoa, NCBuilt 1998 · S/N 525-0284 N25BGSpearfish LLC · St Peters, MOBuilt 2000 · S/N 525-0363 N25DLTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 525-1419 N25PJPjs Aviation LLC · Dunn, NCBuilt 2006 · S/N 525-0607 N260AMQualitair LLC Trustee · MichelstadtBuilt 1998 · S/N 525-0260 N262BKOmicron Business Services Inc · Winter Park, FLBuilt 1998 · S/N 525-0262 N263FBCrye-Leike South Inc · Memphis, TNBuilt 1998 · S/N 525-0263 N267BGCardinal Scale Manufacturing Co · Webb City, MOBuilt 2021 · S/N 525-1078 N26AUnlimited Boat Sales Inc · Page, AZBuilt 1999 · S/N 525-0325

Back to AD 2001-02-13