Registered aircraft · 85,612

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.

N2911WAdduci Alexander Lewis · Trevor, WIBuilt 1979 · S/N 28R-7931253 N2911YBennett John M · Cameron, NCBuilt 1962 · S/N 18253911 N29127Shivers William L Jr · Friday Harbor, WABuilt 1968 · S/N U206-1097 N2912BKilen Enterprises Inc · Mandan, NDS/N 28-7911241 N2912CMarshalee Arizona LLC · Tempe, AZBuilt 1954 · S/N 30812 N2912DSatanta Flying Service Inc · Satanta, KSS/N 26855 N2912MHarriman Aviation LLC · Pearland, TXBuilt 1977 · S/N 28-7890279 N2912VSoaring Twins LLC · Pikeville, NCS/N 34-7970354 N29130Ernst Gregory R · Eagle Creek, ORS/N U206-1100 N29138Allen Brent H · Mammoth Lakes, CABuilt 1973 · S/N 21059815 N2913CUnable Direct LLC · Kalispell, MTBuilt 1954 · S/N 30813 N2913DSale Reported · Nome, AKSale reportedS/N 26856 N2913EG & M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 17271371 N2913UAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1981 · S/N 44-8107057 N29142Hall Darryl Wayne II · Wasilla, AKS/N U206-1112 N29145Rapid Permits LLC · Duck Key, FLS/N 32-7940128 N2914AAvier LLC · Beverly, MABuilt 1979 · S/N 28-7916538 N2914BWhite And Blue Wings LLC · Oakland Park, FLBuilt 1979 · S/N 28-7916539 N2914CSterkel Jared · Anchorage, AKBuilt 1954 · S/N 30814 N2914FHarris Zadok · Upland, CABuilt 1965 · S/N 18257014 N2914GSchubert Matthew · Belleair Beach, FLBuilt 1979 · S/N 28-7990551 N2914KWildness Aviation Limited · Morrison, COS/N 18053127 N2914LPanalucent LLC · Saint Petersburg, FLBuilt 1967 · S/N 670486 N2914RLandrith Robert L · Mustang, OKBuilt 1969 · S/N 28R-35327 N2914USethi Inderdeep S · Tracy, CABuilt 1963 · S/N 17250514 N29151Inland Aerial Surveys Inc · Riverside, CABuilt 1968 · S/N U206-1121 N29157Midwest Aero Inc · Bay City, MIBuilt 1979 · S/N 32-7940130 N29159Southridge Developments Inc · San Miguel, CAFirst renewal noticeBuilt 1974 · S/N 17264103 N2915BRobble Group LLC · Center Valley, PABuilt 1986 · S/N E-2314 N2915CField Jeff H · Simi Valley, CAFirst renewal noticeBuilt 1954 · S/N 30815 N2915DUlrich Craig T · Albany, ORS/N 26858 N2915FStoffregen Thomas S · Milton, WVBuilt 1966 · S/N 18257015 N2915GWalls Properties LLC · Paragould, ARBuilt 1979 · S/N 28-7911243 N2915LZorro Stephen · Rocklin, CABuilt 1967 · S/N 670309 N2915MBlue Sky Aviation Association Inc · Readington, NJS/N 28-7911244 N2915QEtheredge Mark · Pell City, ALS/N 28-7716122 N2915TSierra Canyon Enterprises · Big Bear City, CABuilt 1979 · S/N 28-7921041 N29160Felber Dave A · Florissant, MOBuilt 1974 · S/N 17264104 N29164Iturriria John · Kuna, IDBuilt 1968 · S/N U206-1133 N29168Galer Michael J Jr · Lockwood, MOBuilt 1974 · S/N 17264105 N2916AMetro Service Air Inc · Fairbanks, AKBuilt 1953 · S/N 30116 N2916DWatkins Brad D · Roseburg, ORBuilt 1955 · S/N 26859 N2916FAndros Marketing LLC · Fort Lauderdale, FLBuilt 1966 · S/N 18257016 N2916LPospisil Thomas · Rockwood, PABuilt 1967 · S/N 670310 N2916UJohnson Mark D · Camano Island, WABuilt 1963 · S/N 17250516 N2916WPilots Flying School LLC · Manalapan, NJBuilt 1979 · S/N 44-7995300 N29170Kuhlmann Connor · Ada, MIBuilt 1979 · S/N 32-7940131 N29172Reutter David C · Mount Kisco, NYBuilt 1979 · S/N 32-7940132 N29173Aerial Transport LLC · Wilmington, DEBuilt 1968 · S/N U206-1140 N29176Tgr Helicopters · Fresno, CABuilt 1973 · S/N 21059828

Back to AD 98-21-21 R1