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.

N2515YNationwide Aviation LLC · Weatherford, TXBuilt 1985 · S/N 28-8516074 N2516LFlores E Alex · Missouri City, TXBuilt 1966 · S/N 17255716 N2516ULofton Johnathan V · Springer, OKBuilt 1963 · S/N 17250116 N2516YSchutjer Dennis · Clear Lake, IABuilt 1962 · S/N 17249816 N2516ZBig Sea Enterprises Inc · Wilmington, DEBuilt 1980 · S/N 27-8054039 N2517LCarroll Mark E · Nicholasville, KYBuilt 1966 · S/N 17255717 N2517QPnw Tin Goose LLC · Liberty Lake, WAS/N 32R-7780250 N2517RWaterfront Developers Inc · Hickory, NCBuilt 1969 · S/N 28-5640 N2517YEbnet Joel · Holdingford, MNBuilt 1962 · S/N 17249817 N2517ZGerrety Loren P · Anchorage, AKBuilt 1962 · S/N 185-0517 N2518DKimball Arthur C · Long Beach, CABuilt 1952 · S/N 20670 N2518QSwaldi Thomas · Marion Heights, PABuilt 1966 · S/N 18257718 N2518UMitchell Daniel S · Shavano Park, TXBuilt 1979 · S/N 28-8016027 N2518VFile Thomas A · Shoreline, WABuilt 1948 · S/N 18022 N2518YTracy Michael S · Homer, AKBuilt 1962 · S/N 17249818 N2519L2 G Group LLC · Honolulu, HIBuilt 1966 · S/N 17255719 N2519MCoutcher Michael A · Belleview, FLBuilt 1977 · S/N 28R-7803131 N2519RPentzien Inc · Omaha, NEBuilt 1967 · S/N 18258219 N2519UBradford Murvin L · Hensley, ARS/N 17250119 N251ASMil2atp Inc · Pikeville, NCBuilt 1980 · S/N 34-8070119 N251ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496047 N251BCBearce Larry J · Solon, IAS/N 28R-7803174 N251BWVarsolona Frank L · Las Vegas, NVBuilt 1980 · S/N 25-0299 N251DBSnoopys Air Service LLC · Wappingers Falls, NYBuilt 1968 · S/N 28R-30426 N251EARegistered aircraftBuilt 1969 · S/N 27-4238 N251GT251gt Corp · Oak View, CAS/N CD-251 N251MGGeorgia Aviation Authority · Eastman, GABuilt 2021 · S/N 2881443 N251NDKasowski Flint · Buffalo, NDBuilt 1998 · S/N 2842042 N251RDidier Christopher W · Fay, OKBuilt 1972 · S/N 61139 N251RAReynolds Darryl G · Wills Point, TXFirst renewal noticeBuilt 1975 · S/N 17266249 N251TCTexas State Technical College · Waco, TXBuilt 2025 · S/N 28020241 N251WFWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1979 · S/N 287990548 N2520GGrinch Aviation LLC · Madera, CABuilt 1959 · S/N 51820 N2520LPeck M Hayden II · Bells, TXBuilt 1966 · S/N 17255720 N2520QRcmt Properties LLC · Havre, MTBuilt 1966 · S/N 18257720 N2520RWinston Douglas S · Star, IDBuilt 1967 · S/N 18258220 N2520VSmith Gregory A · Lewistown, MTBuilt 1948 · S/N 18024 N2521CJago River Holdings LLC · Fairbanks, AKBuilt 1954 · S/N 26165 N2521GMountain Aviator LLC · Edwards, COBuilt 1959 · S/N 51821 N2521LExpert Construction Services LLC · Mclean, VAFirst renewal noticeBuilt 1966 · S/N 17255721 N2521RSok Gregory J · Wallingford, CTBuilt 1969 · S/N 28-5641 N2521UN2521u LLC · Danbury, CTBuilt 1979 · S/N 28-8016029 N2521YClanin James Robert · Vandalia, OHBuilt 1962 · S/N 17249821 N2522GMull Morgan · Greensburg, PAS/N 51822 N2522QJohnson Sales & Service Inc · Ong, NEBuilt 1966 · S/N 18257722 N2522RPechanec Brent L · Wichita, KSBuilt 1967 · S/N 18258222 N2522WHollenbeck William M · Montrose, COS/N 17250128 N2522XAce Handyman Services LLC · Sussex, NJS/N P206-0022 N2523CMchenry Thomas Michael Jr · Indialantic, FLBuilt 1954 · S/N 26167 N2523DThomsen Richard · Ladera Ranch, CABuilt 1952 · S/N 20675

Back to AD 98-21-21 R1