Registered aircraft · 47,138

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:2000-23-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21') 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:2000-23-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21')
  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:2000-23-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21')
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.

N31PGPlacette Jim · Houston, TXBuilt 1977 · S/N 310Q0687 N31RTPapuchin LLC · Highwood, ILBuilt 1970 · S/N 414-0158 N31SRIsaac Timothy S · Independence, ORBuilt 1962 · S/N 18051098 N31SWBenwild Aviation LLC · Middleburg, VABuilt 2019 · S/N 4825 N31SXJohnson Shawn Crowley · Green Bay, WIBuilt 2014 · S/N 0861 N31VPBarrett John · Port Hadlock, WABuilt 2009 · S/N LIV-318 N31VRGlaze Roy J · Smyrna, TNBuilt 1976 · S/N 33701731 N31WLAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2003 · S/N 0679 N31WZPulse Line Aviation LLC · Mount Pleasant, SCBuilt 2026 · S/N 11330 N31YBProgressive Air Inc · Janesville, WIBuilt 1979 · S/N 18266786 N31YKJendair LLC · New York, NYBuilt 1973 · S/N 310Q0934 N31ZWestern Skymasters LLC · Salt Lake City, UTBuilt 1973 · S/N P3370028 N3200LRapid Imaging Solutions LLC · American Fork, UTBuilt 1965 · S/N 310J0200 N3200NLazy Bones LLC · Mitchell, SDBuilt 1998 · S/N E-3200 N3200SGreene James · Georgetown, TXBuilt 1964 · S/N 18255700 N3200UAnderson & Assoc Attorneys At Law Pc · Virginia Beach, VABuilt 1962 · S/N 18254600 N3200YCondo Gerardo B · Miami, FLBuilt 1962 · S/N 18254200 N32015Rock Solid Aviation LLC · Lake Charles, LABuilt 1974 · S/N 34-7570007 N3201DMelnick Victor D · Mount Bethel, PABuilt 1955 · S/N 31999 N3201SBoder Eric T · Knoxville, TNBuilt 1964 · S/N 18255701 N3202CJohnson Jeremiah · Fairbanks, AKS/N 18262345 N3202KKennelly Kevin T · Fort Lupton, COBuilt 1946 · S/N 1195 N3203UKuykendall Kirk O · Lakeside, ORS/N 18254603 N3204DGriffith Sherman · Southlake, TXBuilt 1955 · S/N 32002 N3204UBlue Sky Flyers Inc · Punta Gorda, FLBuilt 1962 · S/N 18254604 N3205DWest James · Monroe, MIS/N 32003 N3205UBanducci Debra L Trustee · Bakersfield, CABuilt 1963 · S/N 18254605 N3205VGonzalez Efrain · Manhattan Beach, CABuilt 1994 · S/N E-2899 N3206DDenny Michelle L · Chugiak, AKBuilt 1955 · S/N 32004 N3206JHopman Pablo I · Stow, MABuilt 1994 · S/N EA-568 N3206LAlpha Tango LLC · Omaha, NEBuilt 1976 · S/N D-9951 N3206SHall David J · Red Bluff, CABuilt 1964 · S/N 18255706 N3206YN3206y Aviation LLC · Bloomfield Hills, MIBuilt 1994 · S/N E-2903 N3207LRdl Construction Inc · Hollister, CABuilt 1976 · S/N E-935 N3207SSouthern Star Aviation LLC · El Campo, TXBuilt 1964 · S/N 18255707 N3207UTaf Aerial Services LLC · Beeville, TXBuilt 1963 · S/N 18254607 N3208SZirul James V · Kenai, AKBuilt 1964 · S/N 18255708 N3208UDiller Larry K · Fairview, MIBuilt 1963 · S/N 18254608 N3208YHamilton Triple C Farms · Ririe, IDFirst renewal noticeBuilt 1962 · S/N 18254208 N3209DCirrus 1jr LLC · Webster, NYBuilt 1994 · S/N TH-1735 N3209JDennis John W · Mooresville, NCBuilt 2000 · S/N E-3299 N320BFlorida Keys Aviation Service & Leasing LLC · Key Largo, FLBuilt 1957 · S/N D-5170 N320BTThomas Lance E Trustee · Mesa, AZBuilt 1965 · S/N 320C0048 N320BVLaird Brian N · Monument, COBuilt 2005 · S/N 1 N320CAArmstrong Resource Management Corp · Knoxville, TNBuilt 2014 · S/N 0822 N320CDSimpulse Inc · Oregonia, OHBuilt 2004 · S/N 1248 N320CRBas Part Sales LLC · Greeley, COBuilt 1962 · S/N 320A0003 N320DALorenz John C · Edgewood, NMS/N 61-2986 N320DBBodian Aakil · Martinez, GAS/N 320B0015 N320DFDfig Holdings LLC · Kalispell, MTBuilt 2025 · S/N 11068

Back to AD 2000-23-21