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.

N225TMSouth Of Snow Adventures LLC · Hartwell, GAS/N 318152165 N225TWWallitner Aviation And Restoration LLC · Port Orchard, WABuilt 1959 · S/N DH-219 N225TXCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1979 · S/N 18266946 N225VBas Part Sales LLC · Greeley, COBuilt 1966 · S/N TE-123 N225XGomez Miguel W · Livermore, CABuilt 1957 · S/N D-5032 N22604Tarten Air Inc · Smiths Creek, MIBuilt 1978 · S/N E-1287 N2260GJump Tn LLC · Greeneville, TNBuilt 1958 · S/N 51560 N2260MBomar Robert B · Bedford, TXBuilt 1977 · S/N 28-7816264 N2260PToliver David R · Overland Park, KSBuilt 1957 · S/N 23-870 N2260SWheeler Eugene N · Livermore, CABuilt 1976 · S/N 21061204 N2260TOrtner Airport LLC · Wakeman, OHBuilt 1977 · S/N R18200012 N2261CGandy John W III · Mt Vernon, TXBuilt 1953 · S/N 30561 N2261LGaf Skyborne Aviation Ventures LLC · El Dorado Hills, CABuilt 1979 · S/N E-1535 N2261QAndrews University · Berrien Springs, MIBuilt 1977 · S/N 28-7790386 N2261RPetik Jason P · Sidney, NEBuilt 1968 · S/N T210-0411 N2262FAnchor Aviation LLC · Blue Bell, PABuilt 1978 · S/N 28-7990074 N2262MAg Air Squadron Two LLC · Saint Joseph, ILBuilt 1977 · S/N 28-7816265 N2262QFirst Choice Insurance Partners LLC · Williamston, NCBuilt 1977 · S/N 28-7790387 N2262SKoch Phillip E · Eldon, MOBuilt 1976 · S/N 21061206 N2262TMarsh John E · Washington, DCBuilt 1968 · S/N 185-1420 N2263CWalker William S · Shallotte, NCBuilt 1953 · S/N 30563 N2263QRoss Air Chicago LLC · Chicago, ILBuilt 1977 · S/N 28R-7737030 N2263TUnited States Air Force · Dover Afb, DEBuilt 1977 · S/N R18200014 N2264DKlein James M · Pinconning, MIBuilt 1952 · S/N 20416 N2264GMessner Mark R · Chesapeake, OHBuilt 1958 · S/N 51564 N2264LWoolum Stephanie · Varney, WVBuilt 1976 · S/N TH-771 N2264MArcher Aviation LLC · Orrtanna, PABuilt 1978 · S/N 28-7890237 N2264TTofik Mahir · Cumming, GAS/N 28-7125527 N22650Sackett Gary G · Millcreek, UTFirst renewal noticeBuilt 1972 · S/N 21059767 N2265DPiispanen Norman C · Fairbanks, AKBuilt 1952 · S/N 20417 N2265FRegistration Pending · Wilmington, DERegistration pendingBuilt 1967 · S/N 310L-0065 N2265GWilder James S · Eagle, IDBuilt 1958 · S/N 51565 N2265LNeilsen Lorenzo I · Wilmington, NCS/N D-9939 N2265MEik Baaz LLC · Rocklin, CABuilt 1977 · S/N 28-7890238 N2265QMyl High Flying Club LLC · Mccall, IDS/N 32-7740048 N2265RHodhson Shell S · Wyocena, WIBuilt 1969 · S/N T210-0415 N2266DBeland Steven J Jr · Saint Ansgar, IABuilt 1952 · S/N 20418 N2266FTechnical Education Services Inc · Virginia Beach, VAS/N 310L-0066 N2266MGraves Robert E · Danville, INBuilt 1977 · S/N 28R-7837075 N2266QJudkins James C · Alpharetta, GABuilt 1977 · S/N 32R-7780237 N2266SWeekend Air LLC · Incline Village, NVBuilt 1976 · S/N 21061210 N2266ZLobdell Robert T · Franklinville, NJBuilt 1979 · S/N 28-8090052 N2267AWilson Ronald W · Bluffton, SCBuilt 1969 · S/N D-9027 N2267TAeropod Inc · Aurora, COS/N 185-1427 N22689Ridge View Aviation LLC · Napanoch, NYBuilt 1974 · S/N 17264073 N2268FKephart Peter J · Washington, MOBuilt 1966 · S/N 310L-0068 N2268SPlatinum Air Services LLC · Morgantown, WVS/N R18201317 N2268YMohr Marcia L DBA · New Richmond, WIBuilt 1964 · S/N 30-544 N2269MSpencer Donald I Jr · Knoxville, TNBuilt 1977 · S/N 32R-7880060 N2269PBlackwell Steve · Lewisburg, TNBuilt 1966 · S/N 670152

Back to AD 98-21-21 R1