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.

N1863HSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 34-7770153 N1863JGross Peter J · East Troy, WIBuilt 1968 · S/N 28-24302 N1864CRegistered aircraftBuilt 1953 · S/N 26008 N1864FSwensen Nathan E · Winnemucca, NVS/N 21058764 N1864JBase 2 Final Aviation LLC · Princeton, TXBuilt 1968 · S/N 28-24303 N1864VFrost Dennis J · Appleton, WIBuilt 1974 · S/N 17263774 N1864YHeckendorf Jon W · Ordway, COBuilt 1962 · S/N 17249464 N1865LLiberty Partners Inc · Okmulgee, OKS/N TK-14 N1865SPima County Board Of Supervisors · Tucson, AZS/N 310R0897 N1865TStuart William C · Tullahoma, TNBuilt 1971 · S/N 28-7225013 N1865XAria & Arjun LLC · Cumming, GABuilt 1964 · S/N 18255965 N1865ZBpf Equipment LLC · Burnet, TXBuilt 1962 · S/N 205-0065 N1866CScialabba Samuel S · Emerald Isle, NCBuilt 1966 · S/N CE-60 N1866DFarris Russell L · Fort Mill, SCBuilt 1952 · S/N D-3136 N1867FIcarus Aviators LLC · Canon City, COBuilt 1966 · S/N 21058767 N1867HW Tech Consulting Inc · Kensington, MDBuilt 1977 · S/N 28-7715283 N1867XWaypoint208 LLC · Chubbuck, IDBuilt 1964 · S/N 18255967 N1868HSodah One LLC · San Ramon, CABuilt 1977 · S/N 28-7725165 N1868JCarlisle David · El Paso, TXBuilt 1968 · S/N 28-24309 N1868TShawley James C · Bolivar, MOBuilt 1971 · S/N 28-7225016 N1868VCreative Strategies Inc · Proctorville, OHBuilt 1974 · S/N 17263775 N1868WJohnson Brian D · Glidden, IABuilt 1973 · S/N E-436 N1868ZZulu Forty One LLC · Anchorage, AKBuilt 1962 · S/N 205-0068 N18698Lumpkin Larry T · Ocala, FLBuilt 1969 · S/N 18052076 N1869CSale Reported · Gorham, MESale reportedBuilt 1953 · S/N 26013 N1869FRegistration Pending · Dublin, OHRegistration pendingBuilt 1966 · S/N 21058769 N1869RHarwood John · Waxahachie, TXBuilt 1975 · S/N 28-7690060 N1869TMurray Bryan · Brighton, ILBuilt 1971 · S/N 28-7225018 N1869XFlying Yankees Inc · Nashua, NHBuilt 1964 · S/N 18255969 N1869ZPinnell Bradley T · Lake Havasu City, AZBuilt 1962 · S/N 205-0069 N186AZIz Air LLC · Miami, FLBuilt 1976 · S/N 18503192 N186BBowen John J · Granbury, TXBuilt 1956 · S/N D-4484 N186CAScotland Cay Refuge LLC · Saint Petersburg, FLBuilt 1980 · S/N 32R-8013046 N186CTRegistered aircraftBuilt 1961 · S/N 18050978 N186DMann Thomas A · Ford, WABuilt 1961 · S/N 185-0127 N186FMJett Aviation LLC · Clovis, NMFirst renewal noticeBuilt 1977 · S/N 17269339 N186GMGorosave John Michael · Midland, TXBuilt 1990 · S/N 24-3148 N186KBAims Community College · Greeley, COBuilt 2018 · S/N 2881086 N186MLIdaho Fly Girl LLC · Boise, IDBuilt 1974 · S/N U20602644 N186PPiper Aircraft Inc · Vero Beach, FLS/N 28020293 N186QExecutive Bonanza Group · Sacramento, CABuilt 1964 · S/N D-7644 N186RDWayson Air LLC · Mount Auburn, IABuilt 1966 · S/N 21058761 N186RLN186rl LLC · Fortson, GABuilt 1993 · S/N CE-1748 N186RMAdkins Robert P · Eagle River, AKBuilt 1958 · S/N 51603 N186RWBlake Robert · Gold Creek, MTS/N 18052624 N186RZRex Zollinger Aviation LLC · Woods Cross, UTBuilt 1969 · S/N 18259557 N186SLJls Property Holdings LLC · Athens, TXS/N 23-236 N186SPClear2 Aviate LLC · Ionia, MIBuilt 1977 · S/N 28-7790514 N186SXRodarte Luis Manuel Jr · Tomball, TXS/N 32-8106084 N186THSandy Hook Aviation LLC · Sandy Hook, MSBuilt 1966 · S/N 310L-0029

Back to AD 98-21-21 R1