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.

N193GSWeaver Family Farms LLC · Corpus Christi, TXBuilt 1970 · S/N 18260442 N193KCBig Blessing II LLC · Saint Louis, MOBuilt 2022 · S/N 8857 N193LBRiverway Capital LLC · Houston, TXBuilt 1976 · S/N 20700360 N193RChase David C · Anchorage, AKBuilt 1969 · S/N 182-59879 N193RJSale Reported · Henderson, NVSale reportedBuilt 1980 · S/N R1723315 N193SRScreaming Eagle Aviation Inc · Webb City, MOBuilt 2007 · S/N 2663 N193TATuck Aerial Surveys Inc · Big Stone Gap, VABuilt 1980 · S/N U20605946 N193TTBgiii Air LLC · Tampa, FLBuilt 1976 · S/N 21061601 N193WTHovland Patrick John · Munster, INBuilt 2002 · S/N 1165 N1941MEf Air Holdings LLC · Midkiff, TXBuilt 1976 · S/N 18264493 N1941TErwin Randall L · Johnson City, TNBuilt 1965 · S/N CD-958 N1942MRegistration Pending · Linn, TXRegistration pendingBuilt 1976 · S/N 18264494 N1942XGarrison Weldon · Texarkana, TXBuilt 1979 · S/N P21000296 N1943MBenbrook Robert A · Blairstown, NJBuilt 1977 · S/N 21061968 N1944EHans Construction LLC · Lititz, PAS/N 340A0675 N1945MOchs Roland P · Brighton, COBuilt 1976 · S/N 18264496 N1945XStepps Dana · Humboldt, TNBuilt 1965 · S/N 18256045 N1946VLeading Edge Aviation Inc · Doylestown, PABuilt 1976 · S/N R1722221 N1947MMoeny James A · Cottonwood, AZBuilt 1964 · S/N D-7547 N1947UTri Pacer Air LLC · Pennington, NJBuilt 1946 · S/N NAV-4-394 N1948XGreenwood Auto LLC · Itta Bena, MSBuilt 1965 · S/N 18256048 N1949SDovetail Aviation LLC · Wilmington, NCBuilt 1977 · S/N E-1011 N194ABennett Jay D · Indian Harbour Bch, FLBuilt 1990 · S/N CE-1465 N194CDLehmar LLC · New Orleans, LABuilt 2004 · S/N 1027 N194CMPlanejohn LLC · Minnetonka, MNBuilt 2006 · S/N 1882 N194CPSkywest Aviation Inc Trustee · Albuquerque, NMBuilt 2008 · S/N 3059 N194DCA440 Holdings LLC · Brentwood, TNBuilt 2014 · S/N 0794 N194HAMagnor Clifford E · Fayetteville, NCS/N D-5052 N194LFRidan Investments Inc · Boerne, TXS/N 41630 N194LGSunshine Sky Aviation LLC · Doral, FLBuilt 2006 · S/N 2179 N194NASharrit Edgar W · Sebring, FLS/N D-8409 N194QK & R Aviation LLC · Hollis, NHBuilt 1964 · S/N TC-848 N194SHStipe Robert N · Rawlins, WYBuilt 1979 · S/N 25-0270 N194VUphoff Jeffrey A · Roanoke, VAS/N 29-0200 N1950U3 Stones Productions LLC · Anchorage, AKBuilt 1970 · S/N 18501659 N1950VJenson Kenneth E · Modesto, CABuilt 1980 · S/N 182-67632 N1950XArgyll Aviation II LLC · Kiefer, OKBuilt 1998 · S/N E3174 N1951GClassic Aviation Inc · Pella, IABuilt 2003 · S/N 0630 N1951MFlight Pack LLC · New Bern, NCBuilt 1979 · S/N TC-2255 N1951TBachmann Jochen W · Hudson, OHBuilt 1980 · S/N 185-04134 N1951XSkyline Aircraft Maintenance Inc · Nampa, IDBuilt 1965 · S/N 18256051 N1952HAmpersand Air Inc · Camp Hill, PABuilt 1977 · S/N 28R-7703041 N1952KWard & Ward Management Consultants Inc · Sparta, TNBuilt 2002 · S/N 0147 N1952MLatimore Company LLC · Snohomish, WABuilt 1975 · S/N 33701665 N1953CHanafi Robert A · Wellton, AZBuilt 1953 · S/N 30502 N1953UAnstrand Charles Jason · Boise, IDBuilt 1974 · S/N U20602306 N1954LSmith Cody · Fairbanks, AKBuilt 1966 · S/N U2060751 N1954MBecker Verne L · Manhattan Beach, CABuilt 1976 · S/N 18264500 N1954UAircraft Structural Repair Inc · Hamilton, MTBuilt 1970 · S/N 18501665 N1954XStull David H · Sausalito, CABuilt 1965 · S/N 18256054

Back to AD 2000-23-21