Registered aircraft · 85,614

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

N103RMValiair Lc Trustee · Casper, WYBuilt 1975 · S/N 310R0109 N103RRLancaster Flyers LLC · Fenwick Island, DEBuilt 1979 · S/N 32-7940097 N103RSZielke Michael M · Chuluota, FLBuilt 1957 · S/N 23-1165 N103SAHolman Steven R · Vero Beach, FLBuilt 1983 · S/N 28-8416012 N103SEClear Prop Aviation LLC · Sioux City, IAS/N E-1099 N103SMHermack John F · Toms River, NJBuilt 1978 · S/N E-1267 N103TTAero Dynamics Flying Club Inc · Mulino, ORBuilt 1974 · S/N 28-7505092 N103WWWilkin Richard G · Monticello, ILBuilt 1961 · S/N CD439 N1040FMarrs Matthew D · Bentonville, ARBuilt 1975 · S/N 18502697 N1040HKing Jay M · Kokomo, INBuilt 1976 · S/N 32R-7780124 N1040PShogren Dennis · Grand Terrace, CAS/N R18200368 N1040TTen Forty Tango LLC · Wichita, KSBuilt 1962 · S/N TC-318 N1040UAmerican Aviation Inc · Brooksville, FLS/N 34-7250025 N1040WFoolish Pleasure Aviation Inc · Lewes, DEBuilt 1979 · S/N D-10203 N1040XRacette Robert J Jr · Vienna, WVBuilt 1975 · S/N 28-7515377 N10419C Flying K Aviation LLC · Black Hawk, COBuilt 1976 · S/N T21061484 N1041GN1041g LLC · Charlotte, NCBuilt 1981 · S/N 25-0567 N1041HCentury Flight Systems Inc · Mineral Wells, TXBuilt 1977 · S/N 32R-7780125 N1041MHubbard Bennett L · Piedmont, ALBuilt 1975 · S/N 18264214 N1041QSwaz Aviation LLC · Mesa, AZBuilt 1977 · S/N 28-7716081 N1041SN1041s LLC · Key West, FLBuilt 1977 · S/N 17268658 N1041XGyllensten Scott · Guilford, CTBuilt 1975 · S/N 28-7505199 N1042RSale Reported · Los Angeles, CASale reportedBuilt 1971 · S/N TC-1414 N1042SPiper Cameron · Winchester, VABuilt 1977 · S/N 172-68662 N1042TJbr Leasing Inc · Orlando, FLBuilt 1976 · S/N TJ-79 N1042UShackleford Developments Of Sc LLC · Mount Pleasant, SCBuilt 1971 · S/N 34-7250026 N1042XN1042x LLC · Papillion, NEBuilt 1975 · S/N 28R-7535223 N10433Sodak Angus Inc · Reva, SDBuilt 1951 · S/N 20128 N1043FBakkes Francois · Sitka, AKBuilt 1975 · S/N 18502700 N1043QRegistered aircraftBuilt 1977 · S/N 28R-7737025 N1043SAmerican Aviator LLC · Newark, DEBuilt 1977 · S/N 172-68679 N1043WLatitude Aviation LLC · Cedar Rapids, IABuilt 1973 · S/N CE-423 N1043XAustin Security Corp · Battleboro, NCBuilt 1975 · S/N 28R-7535224 N1043ZJones Property Services Inc · Pelham, ALBuilt 1982 · S/N 24-1337 N10446Schell Brothers II LLC · Rehoboth Beach, DEBuilt 1973 · S/N 172-62515 N1044HWiebe Farms Inc · Hooker, OKS/N 34-7770100 N1044SHubbell Wallis E · Tucson, AZS/N 52829 N1044WAngier 66 LLC · Durham, NCBuilt 1973 · S/N D-9457 N1045Paragon Airplane Leasing Co · Fort Myers, FLBuilt 2024 · S/N 28020177 N1045QWolf Mark W · Long Lake, MNBuilt 1963 · S/N 310H0045 N1045WButler Richard S · Poplar Grove, ILBuilt 1973 · S/N TC-1535 N1046BOglesby Jonathan D · Okmulgee, OKBuilt 1958 · S/N 1273 N1046QAcharya Jay P · Powell Butte, ORS/N 310H0046 N1046UMetzel Peyton S · Libertyville, ILBuilt 1989 · S/N 24-3114 N1046VSusitna Air Service LLC · Anchorage, AKBuilt 1974 · S/N U20602418 N1046XFarnham Aviation Services LLC · Ames, IABuilt 1975 · S/N 28-7525266 N1047AHolt Sheet Metal Inc · Durango, COBuilt 1981 · S/N 25-0571 N1047FBondurant Jok · Talkeetna, AKS/N 18502704 N1047HMagel James · Fox River Grove, ILS/N 28-7715303 N1047MChristiansen Aviation LLC · Wilmington, DEBuilt 2007 · S/N 2842286

Back to AD 98-21-21 R1