Registered aircraft · 85,633

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.

N101PQValiair Limited Company Trustee · Casper, WYBuilt 1962 · S/N 21057932 N101RGTree Air LLC · Vero Beach, FLBuilt 1967 · S/N 18258526 N101RKBlake James R · Marion, LABuilt 1972 · S/N 17261166 N101RMWarren Isaac J · Tucson, AZBuilt 1965 · S/N 28-21184 N101RTBrodine Alan H · Rochester, NYBuilt 1979 · S/N 28R-8018009 N101SLSweet Potato Flying Club LLC · Kalamazoo, MIBuilt 1959 · S/N 23-1832 N101TLojek Donald W · Boise, IDBuilt 1964 · S/N 2887 N101TCTcm Flying Club Inc · Mobile, ALBuilt 1968 · S/N 18259330 N101TKLensing Wayne K · Popular Grove, ILBuilt 1980 · S/N 32R-8029062 N101UAReichard David Elijah · Breinigsville, PABuilt 1960 · S/N 23-1950 N101UKInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N 250631 N101USUsaeroflight LLC · Greenville, SCBuilt 1972 · S/N 17260922 N101UTRudd James M · Lake Jackson, TXFirst renewal noticeBuilt 1971 · S/N 17259900 N101VPN101vp LLC · Ambler, PABuilt 1976 · S/N 28-7790131 N101WCole-Tac LLC · Rapid City, SDBuilt 1980 · S/N 32R-8013087 N101WCRamey Curtis · Hilton Head Island, SCBuilt 1976 · S/N 32R-7680381 N101WEBadgerland Aero LLC · Las Vegas, NVBuilt 1971 · S/N D-9231 N101WPScc Associates Ltd · Wilmington, DEBuilt 1975 · S/N 18264220 N101WSKarnick Mark C · Mesa, AZBuilt 1971 · S/N 17260218 N101YTJagt Terrence L · Crestline, CABuilt 1973 · S/N 28-7310080 N1020DChimera Air Inc · Maumee, OHBuilt 1974 · S/N 28-7425251 N1020HHw Barnhouse Inc · Vero Beach, FLBuilt 1968 · S/N 30-1569 N1020MWinner Philip · Houston, TXBuilt 1975 · S/N 18264208 N1020UNorth Central Aircraft Sales · Tioga, NDS/N 18783 N1020VCraig Air Inc · Wasilla, AKBuilt 1974 · S/N U20602404 N1021CRiener Clinton G · Cottonwood, IDBuilt 1966 · S/N 18257409 N1021KVranjes Miron · Mercer Island, WAS/N 24-3104 N1021WGreystone Enterprises Inc · Oklahoma City, OKBuilt 1973 · S/N E-401 N1021XO-D LLC · Kalispell, MTBuilt 1975 · S/N 28R-7535219 N1022FGoodfellow Malcolm D · Seattle, WABuilt 1975 · S/N 18502690 N1022MHilton David L · Shreveport, LABuilt 1975 · S/N 18264209 N1022THansen Jed D · Clark, SDS/N D-3144 N1022XLeggett Air LLC · Cairo, GABuilt 1975 · S/N 28R-7535220 N1023FWinter Karl · Litchfield Park, AZBuilt 1975 · S/N 18502691 N1023WGoldeagle Flyers Inc · San Jose, CABuilt 1973 · S/N CE-421 N1023XBickley David R · Pocatello, IDBuilt 1975 · S/N 28-7510074 N1024Calgonaire LLC · Seminole, TXS/N 57425 N10242Alexander Holding Services Inc · Newark, DEFirst renewal noticeBuilt 1972 · S/N 21059704 N1024CLarsen Johannes · Sterling, MAS/N 24-1113 N1024HBellville Timothy L · Toledo, OHS/N 28-7715302 N1024MEdwards Chris R · Meadow Vista, CABuilt 1975 · S/N 18264210 N1024QDuroc LLC · Watertown, WIBuilt 1977 · S/N 28-7790370 N1024TBarnwell John Randel · Conroe, TXBuilt 1976 · S/N D-9941 N1024U24u Aviation LLC · Wilmington, DEBuilt 1971 · S/N 34-7250004 N1025MSupina Robert P · Richmond, TXBuilt 1975 · S/N 18264211 N1025WBancroft Maurice J · Rio, WIBuilt 1973 · S/N D-9453 N1025XCrosswind Aviation Of Oklahoma LLC · Stillwater, OKBuilt 1975 · S/N 28-7525261 N1026BBazler Jack A Trustee · Boulder, COBuilt 1956 · S/N LH-163 N1026HNeedham John A · Southington, CTBuilt 1973 · S/N 28-7325489 N1026MStinar Gary F · Lakeville, MNBuilt 1970 · S/N 17259406

Back to AD 98-21-21 R1