Registered aircraft · 85,620

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.

N1936TN1936t LLC · Franklin Park, NJBuilt 1971 · S/N 28-7105154 N1936XNelson William T · Benton, KYBuilt 1965 · S/N 18256036 N19370Clanton Ronald W · Aurora, COBuilt 1968 · S/N 17257181 N1937CJensen Deleigh S · Dell Rapids, SDBuilt 1953 · S/N 26082 N1937FA2 Flight Leasing LLC · Castro Valley, CABuilt 1979 · S/N 17273027 N1937HTerra Alfred Jr · Taunton, MABuilt 1977 · S/N 28-7790358 N1937KGriffin Contracting Co · Bloomfield, MOS/N 3213091 N1937MPoultry Not Beef LLC · Chancellor, ALBuilt 1976 · S/N 18264490 N1937TChristianson Eric L · Peoria, AZBuilt 1971 · S/N 28-7125490 N1937XOrtiz Marquez Ricardo A · Melbourne, FLBuilt 1965 · S/N 18256037 N1937YTirado Josue · Pembroke Pines, FLBuilt 1964 · S/N 244 N1938DPlane Crazy Aviation LLC · Hickory, NCBuilt 1952 · S/N D-3214 N1939GMorgan Larry D · Blair, NEBuilt 1989 · S/N 2890107 N1939HChicas-Terrill Roger Daniel · Anaheim, CABuilt 1977 · S/N 28R-7737018 N1939X1939xray LLC · Chester, SCBuilt 1965 · S/N 18256039 N1939YMcconnell Kristopher P · Nampa, IDFirst renewal noticeBuilt 1964 · S/N 246 N193DC310 Charter LLC · Zanesville, OHBuilt 1980 · S/N 310R1885 N193DRLinden Elizabeth M · Mc Farland, WIS/N 193 N193GSWeaver Family Farms LLC · Corpus Christi, TXBuilt 1970 · S/N 18260442 N193JSRyan Moore LLC · Fayetteville, NCBuilt 1975 · S/N 17265118 N193LHPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010067 N193MBSmith Paul A · Trufant, MIBuilt 1979 · S/N 28-7911104 N193RChase David C · Anchorage, AKBuilt 1969 · S/N 182-59879 N193TATuck Aerial Surveys Inc · Big Stone Gap, VABuilt 1980 · S/N U20605946 N193TTBgiii Air LLC · Tampa, FLBuilt 1976 · S/N 21061601 N193WMCarter Jason W · Owens Cross Roads, ALBuilt 1970 · S/N 28-5795 N1940FAmerican Asset Leasing LLC · Livermore, CAS/N 17273030 N1940TC140 Co LLC · Milton, FLBuilt 1971 · S/N 28R-7135138 N1940YMiller Rollie R · Dillon, MTBuilt 1964 · S/N 247 N19411Taylor Fred H · Plano, TXFirst renewal noticeBuilt 1969 · S/N 690085 N1941MEf Air Holdings LLC · Midkiff, TXBuilt 1976 · S/N 18264493 N1941TErwin Randall L · Johnson City, TNBuilt 1965 · S/N CD-958 N1941VSale Reported · Bloomburg, TXSale reported, canceledBuilt 1984 · S/N 28-8490056 N1942CPfister Robert T · Stuart, FLBuilt 1953 · S/N 26087 N1942DFrancis David L · Fort Worth, TXBuilt 1952 · S/N D-3219 N1942JFlybird LLC · East Northport, NYBuilt 2003 · S/N 3246216 N1942MRegistration Pending · Linn, TXRegistration pendingBuilt 1976 · S/N 18264494 N1942TGullion Monte C · Scottsburg, INBuilt 1971 · S/N 28-7105155 N1942XGarrison Weldon · Texarkana, TXBuilt 1979 · S/N P21000296 N1942ZThird Step 5 LLC · Gilbert, AZS/N 28-22849 N1943CLacey Miles H · Valley Springs, SDBuilt 1953 · S/N 26088 N1943DHartman Dylan · Avon, INBuilt 1952 · S/N D-3221 N1943MBenbrook Robert A · Blairstown, NJBuilt 1977 · S/N 21061968 N1943TFuhrman Ronald A · Fargo, NDBuilt 1971 · S/N 28-7105156 N1944C1944 Charli LLC · Bristol, CTBuilt 1953 · S/N 26089 N1944TBeen Flying LLC · Colchester, CTBuilt 1971 · S/N 28-7125497 N1944YHolcombe Thomas Hg · Moss, TNBuilt 1964 · S/N 251 N1945CWassman Dennis B · Moraga, CABuilt 1953 · S/N 26090 N1945FLake Elmo Aero LLC · Lake Elmo, MNBuilt 1979 · S/N 17273035 N1945MOchs Roland P · Brighton, COBuilt 1976 · S/N 18264496

Back to AD 98-21-21 R1