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.

N267HHSankaran Mahesh · Amherst, NYBuilt 2014 · S/N 0878 N267JSDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1976 · S/N 347670332 N267LMAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1979 · S/N P21000362 N267PJune26 Investments LLC · Pinehurst, NCBuilt 2026 · S/N 11302 N267PDWhite Hat Repair LLC · Greenleaf, IDBuilt 1967 · S/N TE-284 N267PKRegistration Pending · Summerville, GARegistration pendingBuilt 2014 · S/N 4156 N267WTTaylor Mark T · Walnutport, PABuilt 2019 · S/N 2019 N2680FWatkins Jeffrey M · Auburn, CABuilt 1965 · S/N 18256780 N2680GTodd Larry D · Wasilla, AKBuilt 1959 · S/N 51980 N2680YReid Brian M · Boise, IDBuilt 1962 · S/N 18051180 N2681GRhea Higher Education And Aviation LLC · Prescott, AZBuilt 1959 · S/N 51981 N2681XZimmer Roy E Jr · Winter Park, FLBuilt 1965 · S/N P206-0181 N2682AAnacortes Associates LLC · Anacortes, WABuilt 1969 · S/N D-9045 N2682GFlying L Aircraft Inc · Fort Denaud, FLBuilt 1959 · S/N 51982 N2682RRadeka Michael · East Machias, MES/N 18258382 N2683GEtc Aircraft LLC · Anchorage, AKFirst renewal noticeS/N 51983 N2683RNance James H II · Grants Pass, ORBuilt 1967 · S/N 18258383 N2684FFelts Anthony E · Groveland, CAS/N 18256784 N2684QJastram Benjamin C · Lafayette, LABuilt 1966 · S/N 18257884 N2684VReims Rocket LLC · Tempe, AZBuilt 1976 · S/N R1722227 N2685FBabovic Slobodan · Elm Grove, WIBuilt 1965 · S/N 18256785 N2685QMcelmoyl John W · Greenfield, CABuilt 1966 · S/N 18257885 N2685XWorden Andrew · Burlington, COS/N 18255311 N2686FKing Cara Jean · Deland, FLBuilt 1965 · S/N 18256786 N2686QLines Daniel R · Roseburg, ORBuilt 1966 · S/N 18257886 N2687FT Air LLC · Columbia Falls, MTBuilt 1965 · S/N 18256787 N2687QKnorr John Lee · Puposky, MNBuilt 1966 · S/N 18257887 N2687RSpangler Keith · Monroeville, INBuilt 1967 · S/N 18258387 N2688DB2 Air LLC · Pierre, SDBuilt 1979 · S/N 414A0332 N2688FWagosh Aviation LLC · Flagstaff, AZBuilt 1965 · S/N 18256788 N2688MAlcyone Trust Corp Trustee · Wichita, KSBuilt 1979 · S/N 414A0334 N2688RShaw Thomas B · Hobbs, NMBuilt 1967 · S/N 18258388 N2688XDw Hamm Consulting LLC · Malibu, CABuilt 1979 · S/N 414A0336 N2689CColvin Clu DBA · Big Cabin, OKS/N 35089 N2689DRegistration Pending · Greenwood, MSRegistration pendingS/N 414A0401 N2689GShandog Air LLC · Ashland, KYBuilt 1979 · S/N 414A0402 N2689JFinley Taylor J · Colby, KSBuilt 1979 · S/N T18803497T N2689QKirschke John K · Seneca Falls, NYBuilt 1966 · S/N 18257889 N2689RMortensen Mark S · Hamilton, MTBuilt 1967 · S/N 18258389 N268ACPafford David A · Floydada, TXBuilt 1998 · S/N 25-2024 N268AFApogee Flight Inc · Bellingham, WABuilt 1961 · S/N G-828 N268CDKahng Jim · Torrance, CABuilt 2003 · S/N 0436 N268DLCrenshaw Robert L · Goldsboro, NCBuilt 1969 · S/N P206-0570 N268PBeaulot LLC · East Aurora, NYBuilt 2006 · S/N E-3750 N268RKalhart Transportation Services Inc · Rancho Santa Fe, CABuilt 1977 · S/N E1092 N268SAInarayan Inc · Winter Park, FLBuilt 1963 · S/N TC-554 N268SRCirrus Design Corp · Duluth, MNBuilt 2007 · S/N 2334 N268WGolf Links Inc · Hermitage, TNBuilt 2006 · S/N 42542 N268YMilton Quincy N · Bellevue, WABuilt 1959 · S/N 35846 N2690AHamons Jeffery W · Perrysburg, OHBuilt 1978 · S/N E-1264

Back to AD 2000-23-21