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.

N2710JPeople Incorporated Of Virginia · Abingdon, VABuilt 1979 · S/N 335-0043 N2710XReinhart Richard A · Cook, MNBuilt 1965 · S/N 18051510 N27117Chalfant William Paxson III · Concord, NCBuilt 1979 · S/N E-1416 N2711GAlexander Marshall J · Klamath Falls, ORBuilt 1959 · S/N 52011 N2711NMountain Air Aviation LLC · Fruit Heights, UTBuilt 1980 · S/N 335-0050 N2711YAnn Arbor Air LLC · Plymouth, MIBuilt 2002 · S/N 1211 N2712FDodson International Parts Inc · Rantoul, KSBuilt 1978 · S/N 402C0121 N2712QGrotbeck Carter L · Albuquerque, NMBuilt 1967 · S/N 18257912 N2712TJames Todd E · Lebanon, PAS/N TE-349 N2713GPalmer Carroll W · Harper, ORBuilt 1959 · S/N 52013 N2713QJeff Jones Aircraft Company LLC · Quincy, WABuilt 1967 · S/N 18257913 N2714CLipcon James P · Stow, MABuilt 2005 · S/N 1393 N2714FDdh LLC · Goddard, KSBuilt 1965 · S/N 18256814 N2714GRegistered aircraftBuilt 1959 · S/N 52014 N2714TVertical Flight Leasing LLC · Wilmington, DEBuilt 1967 · S/N D-8438 N2715FLow Wings Aviation LLC · Gassville, ARBuilt 1965 · S/N 18256815 N2715TDelaware Aircraft Trust LLC Trustee · New Castle, DES/N 402C0214 N2716XShaw Brandon L · Juneau, AKBuilt 1965 · S/N 18051516 N2717AMitchell Matthew · Roanoke, TXBuilt 1969 · S/N D-9049 N2717GKlotz Terrance M · Sparks, NVBuilt 1959 · S/N 52017 N2717TIberlin James M · Gillette, WYBuilt 1967 · S/N TE-351 N2718AOmega2alpha Services LLC · Brock, TXBuilt 1969 · S/N CD-1231 N2718FJackalope Flyers LLC · Whitefish, MTBuilt 1965 · S/N 18256818 N2718QJenerette Marcus · Galivants Ferry, SCBuilt 1967 · S/N 18257918 N2718XPoirier Theodore N · Biddeford, MEBuilt 1965 · S/N 18051518 N2718YRichland Aviation Inc · Sidney, MTBuilt 1979 · S/N 402C0232 N2719CBrown Kevin Charles · Round Rock, TXBuilt 1977 · S/N 28R-7803034 N2719FSjoblom Erik Anders · Washington Twp, MIBuilt 1966 · S/N 18256819 N271CPCharlie Hotel Mike LLC · Lincoln, NEBuilt 2010 · S/N 0044 N271EOuray Ventures LLC · San Diego, CABuilt 2015 · S/N 1157 N271NPJust Plane Stuff Inc · Jackson, MSBuilt 2024 · S/N 10043 N271PBClark Mayer Aviation LLC · Cross Roads, TXBuilt 1997 · S/N TH-1840 N271SBowker Mark · Bowdoinham, MEBuilt 1974 · S/N TC-1791 N271SRGriffin James R · Pinedale, WYBuilt 2007 · S/N 2714 N271WMFarm Dog Holdings LLC · Reedley, CABuilt 2024 · S/N 9931 N2720ABaron N2720a LLC · Faulkton, SDBuilt 1978 · S/N TK-69 N2720GGenstler Jeremy A · Apple Valley, CABuilt 1959 · S/N 52020 N2720QDelta Yankee Aviation LLC · Anguilla, MSBuilt 1967 · S/N 18257920 N2720TMiller Mark · Bellevue, WABuilt 1967 · S/N D-8441 N2720XStubbs John C · Bangor, MEBuilt 1965 · S/N 18051520 N2721QN2721q LLC · Stuart, FLBuilt 1967 · S/N 18257921 N2721TGalvin Peter · Laytonsville, MDBuilt 1967 · S/N D-8443 N2722AMontgomery Douglas Tanner · San Antonio, TXBuilt 1969 · S/N D-9050 N2722GEpperson David C · Salt Lake City, UTFirst renewal noticeBuilt 1959 · S/N 52022 N2722XRearden Michael B · Homer, AKBuilt 1965 · S/N 18051522 N2723FTrantham Robert Keith · Alexandria, ALBuilt 1966 · S/N 18256823 N2723GReno Timothy J · University Place, WABuilt 1959 · S/N 52023 N2724FIsley Rocky · Lacey, WABuilt 1965 · S/N 18256824 N2724JHorseshoe Air LLC · Pella, IAS/N 185-1474 N2724TWittenbrader Jeff · Lake Ariel, PABuilt 1967 · S/N TE-354

Back to AD 2000-23-21