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.

N2562QStiles Thomas W · Pocahontas, ILBuilt 1966 · S/N 18257762 N2562RKehler Grain & Livestock · Saint Xavier, MTBuilt 1967 · S/N 18258262 N2562UJust Plane People LLC · Irvine, CABuilt 1979 · S/N 28-8090056 N25631Myers Robert G · Monument, COBuilt 1973 · S/N TC-1523 N25632Struck Larry G · Gardnerville, NVS/N D-9435 N25633Paolercio Alan D · Grants Pass, ORBuilt 1973 · S/N D-9438 N2563SClements Kenneth Brian · Las Vegas, NVBuilt 1976 · S/N 21061330 N2563UGrande Philip M · Mt Laurel, NJBuilt 1979 · S/N 28-8090057 N2563VSchneider Gregory M · Bridger, MTS/N 18068 N2563ZWien Richard A · Fairbanks, AKBuilt 1963 · S/N 185-0563 N25642Pester Jerome B · Hingham, MTBuilt 1973 · S/N CE-457 N25647Segura Richard J III · Henderson, TXBuilt 1973 · S/N TH-301 N2564GGarrison Jeffrey R · Clemson, SCBuilt 1959 · S/N 51864 N2564RBusse William J · Twin Lakes, WIBuilt 1967 · S/N 18258264 N2564UBurris Bruce · Deer Park, WAS/N 17250164 N2564WReynolds Stuart N II · Church Road, VABuilt 1965 · S/N 3270 N2564YBrewer George H · Muskegon, MIBuilt 1962 · S/N 17249864 N2564ZDownwind Aviation LLC · Kodiak, AKBuilt 1963 · S/N 185-0564 N25659Greenery LLC · Wilmington, DEBuilt 1973 · S/N TC-1596 N2565CFolgner Robert E · Dana Point, CARegistration revokedBuilt 1954 · S/N 26209 N2565GMoore Timothy L · Wendell, IDBuilt 1959 · S/N 51865 N2565MMacair Aviation LLC · Xenia, OHBuilt 1977 · S/N 28-7890257 N2565RSanders David D · Alvin, TXBuilt 1967 · S/N 18258265 N2565UVintage Flyers Inc · Napa, CABuilt 1979 · S/N 28-8090058 N25662Atcnavion LLC · Hinckley, OHBuilt 1973 · S/N D-9522 N25665Franks Bryan · Camarillo, CABuilt 1973 · S/N CE-459 N25667Bushnell Alison M · Phelan, CABuilt 1973 · S/N E-468 N2566CJohnson James K · Sandy Valley, NVBuilt 1954 · S/N 26207 N2566QCarothers Rayburn T · Brevard, NCBuilt 1977 · S/N 28-7725201 N2566RRastetter Harold · Douglaston, NYBuilt 1967 · S/N 18258266 N2566UHighland Aero LLC · Mcminnville, TNBuilt 1980 · S/N 28-8090059 N2566YAns Aircraft LLC · Midland, TXS/N 17249866 N25675Todd James Michael · Angleton, TXBuilt 1973 · S/N E-472 N25676Ciabattoni David E · Wallingford, PABuilt 1973 · S/N TC-1597 N2567DHaasl Glen D · Chugiak, AKBuilt 1952 · S/N 20719 N2567GSunrise Exploration Inc · Northport, WABuilt 1959 · S/N 51867 N2567KBryant Kenneth D · Black Diamond, WABuilt 1978 · S/N 18052990 N2567RGone Flying LLC · Loveland, OHBuilt 1967 · S/N 18258267 N2567URegistration Pending · Fort Worth, TXRegistration pendingBuilt 1963 · S/N 17250167 N2567WSullivan Eric V · Santa Barbara, CABuilt 1965 · S/N 3271 N25681Heli-Ventures Inc · Wilmington, DEBuilt 1973 · S/N CE-460 N2568GKoechen Wayne L · Cooper Landing, AKBuilt 1959 · S/N 51868 N2568MDe La Cruz Ronaldo · Cape Coral, FLBuilt 1979 · S/N 27-7954079 N2568QCasey William · Celina, TXBuilt 1977 · S/N 28-7716113 N2568RCraven James J · Pensacola, FLBuilt 1969 · S/N 28-5649 N2568ULuce Mark E · Tucson, AZBuilt 1963 · S/N 17250168 N2568VFarringer Steven R · Columbia City, INBuilt 1948 · S/N 18073 N2568WSale Reported · Modesto, CASale reportedBuilt 1965 · S/N 3272 N2568XPeasley Casey · Eagle, IDBuilt 1965 · S/N P206-0068 N25691Marty Daniel A · Birmingham, ALBuilt 1973 · S/N CE-462

Back to AD 98-21-21 R1