Registered aircraft · 13,306

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:2012-10-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:2012-10-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:2012-10-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:2012-10-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:2012-10-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:2012-10-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.

N216DHRebel One LLC · Dover, DEBuilt 2015 · S/N 4270 N216GLDvhoops Holdings LLC · Dakota Dunes, SDBuilt 2018 · S/N 1733 N216HBMorganaire LLC · Flowery Branch, GABuilt 2024 · S/N 10274 N216LBell John · Linville, NCBuilt 2004 · S/N 1111 N216LBBail Air LLC · Port Saint Lucie, FLBuilt 1974 · S/N 414-0545 N216LHHackbarth Lee A · Bend, ORBuilt 1981 · S/N U20606057 N216NGrb Aircraft Leasing LLC · West Fargo, NDBuilt 2008 · S/N 3117 N216PBDivine Air LLC · Brookshire, TXBuilt 2025 · S/N 10924 N216SYWings Flights Of Hope Inc · Orchard Park, NYBuilt 2016 · S/N 1280 N2170BReiheld Amelia T · Edenton, NCBuilt 1999 · S/N 30-0002 N21737Eagle Series A Separate Series Of · Houston, TXBuilt 1999 · S/N 30-0004 N2174JSafa Masoud · San Francisco, CABuilt 1999 · S/N 30-0005 N21786Affinity Insurance Partners Inc DBA · Clearwater, FLBuilt 1999 · S/N 29-0194 N2179WAlbertin Ricardo · Washington, DCBuilt 1999 · S/N 30-0033 N217CEHardgrave Kenneth K · Texas City, TXBuilt 2011 · S/N 3812 N217CTLethalairllc · Camden, DEBuilt 2017 · S/N 1475 N217ETAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2010 · S/N 3637 N217GMMarcom Michael D · Valley View, TXBuilt 2010 · S/N 3688 N217JFBcd Aviation LLC · Chicopee, MABuilt 2014 · S/N 0932 N217JKRamp Air LLC · Clayton, NCBuilt 2019 · S/N 1901 N217LJFessenden Hart W · Port Orange, FLBuilt 2000 · S/N E-3334 N217PCClearwater Consultants Inc · Starkville, MSBuilt 2000 · S/N E-3330 N217SCJtfs LLC · Huntsville, ALBuilt 1999 · S/N E-3221 N217SKThrust Aviation LLC · George West, TXBuilt 2014 · S/N 0817 N217SLJ & J Aviation LLC · Lafayette, LABuilt 2017 · S/N 4539 N217SRAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 2118 N217SYRegistration Pending · Pratt, KSRegistration pendingBuilt 2017 · S/N 1595 N217TJBb Air LLC · Fayetteville, NCBuilt 2006 · S/N 2291 N217YWhisper Rock LLC · San Antonio, TXBuilt 2017 · S/N 1629 N2181SGreer Kenneth R · Pittsburgh, PABuilt 1975 · S/N 21061142 N2182HSpangler & Pion LLC · Davis, CABuilt 1996 · S/N 29-0095 N2183ALee Christopher M · Port Jervis, NYBuilt 1999 · S/N 29-0198 N21843Robertson James D Trutee · Mountain View, CABuilt 2000 · S/N 29-0220 N2184NPlane Convenient LLC · Canton, OHBuilt 1999 · S/N 30-0039 N2186JRsp Wealth Strategies LLC · Glen Allen, VABuilt 2000 · S/N 30-0047 N218BJCatalina Sky Aviation LLC · San Diego, CABuilt 2019 · S/N 2030 N218CCSotally Tober LLC · Wilmington, DEBuilt 1979 · S/N 21063297 N218CFLevel 200 LLC · Charlottesville, VABuilt 1980 · S/N 340A0989 N218DPSmb Consulting And Investing LLC · Jamison, PABuilt 2006 · S/N 1800 N218EMAir Travel & Transportation Services LLC · Atlantic Beach, FLBuilt 2007 · S/N 2511 N218HGDesert Aviation LLC · Kingman, AZBuilt 2017 · S/N 1632 N218HLCapital Flight LLC · El Paso, TXBuilt 2016 · S/N 1310 N218LJFoster James L · Bryan, TXBuilt 2007 · S/N 2673 N218LMKrause Cody · Clear Lake, SDBuilt 2003 · S/N 0501 N218PM218pm LLC · Fort Collins, COBuilt 2002 · S/N 0201 N218RHRjh Capital Holdings LLC · Newark, DEBuilt 2021 · S/N 2352 N218RWGba Holdings LLC · Carson City, NVBuilt 2020 · S/N 2066 N218SRTs Joyce Aviation LLC · West Fargo, NDBuilt 2006 · S/N 2074 N218SY46u LLC · Anaconda, MTBuilt 2018 · S/N 1720 N218VBCornelius Brett · Brentwood, TNBuilt 2016 · S/N 1378

Back to AD 2012-10-13