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.

N730GYG&Y Airline LLC · Longview, TXBuilt 2019 · S/N 525-1016 N731DCSunshine Aviation LLC · Jackson, TNBuilt 2019 · S/N 525-1039 N732MTextron Aviation Inc · Wichita, KSBuilt 2008 · S/N 525-0685 N741CCBlake Aviation Enterprises LLC · Fort Worth, TXBuilt 1997 · S/N 525-0227 N747ACGoing Going Gone LLC · North Las Vegas, NVBuilt 1997 · S/N 525-0202 N747HZLewis Aeronautical LLC · San Antonio, TXBuilt 2022 · S/N 525-1108 N748BL755 Holdings LLC · Tiffin, OHBuilt 2022 · S/N 525-1116 N74KMCyd Aviation LLC · Austin, TXBuilt 2014 · S/N 525-0800 N75LTLaughing Giraffe Aviation LLC · Millsboro, DEBuilt 1998 · S/N 525-0241 N75VKMaranatha Leasing & Consulting Inc · Marco Island, FLBuilt 2019 · S/N 525-1042 N76GPGp Flight Group LLC · Petaluma, CABuilt 2023 · S/N 525-1151 N76YTJack Straw Development LLC · Tempe, AZBuilt 2009 · S/N 525-0687 N774JTRegistration Pending · Springfield, MORegistration pendingBuilt 2020 · S/N 525-1065 N775TBCj Partners LLC · Springfield, ILBuilt 1994 · S/N 525-0075 N777BPFloss Five Ten LLC · Lewisville, NCBuilt 2018 · S/N 525-0986 N77DBDarrigo Bros Co Of California · Salinas, CABuilt 2001 · S/N 525-0443 N77KNAlta Aviation LLC · Phoenix, AZBuilt 2014 · S/N 5250821 N780ABEagle Wings Aviation LLC · Canton, MABuilt 1994 · S/N 525-0073 N780DCAllard Air Services Inc · Scottsdale, AZBuilt 2016 · S/N 525-0910 N783DLAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2021 · S/N 525-1075 N785PDOrchard Elms LLC · North Ogden, UTBuilt 2025 · S/N 525-1193 N788JWNorth Fork Place LLC · Bozeman, MTBuilt 2020 · S/N 525-1050 N78TJKcs Aviation LLC · Columbia, TNBuilt 2015 · S/N 525-0864 N793CJAgl Lease LLC · Grand Rapids, MNBuilt 2000 · S/N 525-0021 N794PFPrestage Farms Of South Carolina LLC · Camden, SCBuilt 2007 · S/N 525-0649 N797BKBlue Bird Of Happiness LLC · Shreveport, LABuilt 2018 · S/N 525-1001 N79AJCal Avia LLC · Fresno, CABuilt 1999 · S/N 525-0321 N7CQEfc Aircraft LLC · Missoula, MTBuilt 1993 · S/N 525-0004 N7MHFlying Hare LLC · High Point, NCBuilt 1994 · S/N 525-0081 N800DTN800dt LLC · Wilmington, DEBuilt 1994 · S/N 525-0092 N800NBN800nb LLC · Minneapolis, MNBuilt 1997 · S/N 525-0212 N805CJIcbs Aviation LLC · Allen, TXBuilt 2005 · S/N 525-0603 N805PN805p LLC · Greenwood Village, COBuilt 2011 · S/N 525-0701 N805VCPhillips Air Ventures LLC · Tulsa, OKBuilt 1994 · S/N 525-0076 N806CM806 Assets LLC · Horseshoe Bay, TXS/N 525-0875 N80YBYork Aircraft Equities LLC · York, PABuilt 2024 · S/N 525-1183 N810SSNgo Aviation LLC · Lafayette, LABuilt 1996 · S/N 525-0137 N811JLSolera Aviation LLC · Bozeman, MTBuilt 2021 · S/N 525-1090 N813FMKevin Parra Aviation LLC · San Diego, CABuilt 2015 · S/N 525-0884 N814DMSix Romeo Mike LLC · Billings, MTBuilt 2000 · S/N 525-0376 N814LG814 Lima Golf LLC · Fayetteville, ARS/N 525-0534 N815MCEfficiency Aloft LLC · Santa Rosa, CABuilt 1996 · S/N 5250142 N817HCHudson Air LLC · Henagar, ALBuilt 2001 · S/N 5250459 N818FC609jr LLC · Bozeman, MTBuilt 1994 · S/N 525-0059 N81CP78cl Aviation LLC · Ogden, UTBuilt 2007 · S/N 525-0633 N820JTRegistered aircraftBuilt 2015 · S/N 525-0870 N821CDJ & B Quick Air LLC · Overland Park, KSBuilt 2016 · S/N 525-0922 N822JAWings Of Justice LLC · Bozeman, MTBuilt 2021 · S/N 525-1094 N822TBOrscm2 LLC · Upland, CABuilt 2022 · S/N 525-1110 N825MT376sb LLC · Lexington, KYBuilt 2014 · S/N 525-0825

Back to AD 2001-02-13