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.

N2077DKloster Ethan · Tarzana, CABuilt 1953 · S/N D-3429 N2077GSharp Robert M Trustee · Jenks, OKBuilt 1958 · S/N 51377 N2077TThoendel Joshua R · O' Neill, NEFirst renewal noticeBuilt 1970 · S/N 28R-7135021 N20784Dbab LLC · Belleville, ILBuilt 1978 · S/N 28-7990025 N20785Villa Axel · Orlanda, FLS/N 18261201 N20786State Of Alaska · Anchorage, AKBuilt 1976 · S/N 18503042 N20787Crawford Donald Mark · Frisco, TXBuilt 1978 · S/N 32-7840181 N20789Johnson Laurel D · Newcastle, WABuilt 1974 · S/N 17263837 N2078ARyan John T · Salina, KSBuilt 1978 · S/N 28R-7837315 N2078BD & P Jones Enterprises Inc · Santa Cruz, CABuilt 1979 · S/N 32R-7987022 N2078GCasaus Santos · Rio Rancho, NMS/N 51378 N2078RCustom Aviation LLC · Butler, PABuilt 1964 · S/N 18255278 N2078TMavity Michael D · Phoenix, AZBuilt 1970 · S/N 28R-7135022 N2078WLawrence Dayle DBA · Scotia, CABuilt 1966 · S/N TE-83 N2078YBell Jason S · Coos Bay, ORBuilt 1962 · S/N 17249578 N20791L A M Capital Management LLC · Sheridan, WYBuilt 1972 · S/N 18261207 N20792Boyette Donnie R · Kenly, NCBuilt 1974 · S/N 17263838 N20793Bas Part Sales LLC · Greeley, COBuilt 1972 · S/N 18261209 N20797N20797 LLC · Odessa, FLBuilt 1972 · S/N 18261213 N2079GStaiano Salvatore G · Flemington, NJBuilt 1958 · S/N 51379 N2079LPlatinum Aviation LLC · Belvidere, TNS/N E-872 N2079MMg Aircraft Ltd · Sidney, OHBuilt 1977 · S/N 28R-7803106 N2079NSkywarrior Flight Training Inc · Pensacola, FLBuilt 1979 · S/N 44-7995214 N2079RBrian K Vittorini · Bridgeton, NJBuilt 1969 · S/N 28-5455 N2079TCraig James A · Salt Lake City, UTBuilt 1970 · S/N 28R-7135023 N2079WCoast Flight Training And Management Inc · San Diego, CABuilt 1979 · S/N 44-7995270 N2079XDe Flyers LLC · Vicksburg, MIBuilt 1979 · S/N 32R-7987120 N2079YNoel Steve E Trustee · Fort Wayne, INBuilt 1979 · S/N 28R-7931140 N207ABCoco Aircraft Inc · Merritt Island, FLBuilt 1989 · S/N 2841284 N207AFFlying Burros Air Trucking Co · Wilmington, DEBuilt 1955 · S/N CH-144 N207CBCalifornia Baptist University · Riverside, CABuilt 2017 · S/N 2881001 N207DWest Coast Aircraft LLC · Carson City, NVBuilt 1957 · S/N D-3461 N207ECCianchette Eric · Falmouth, MEBuilt 1952 · S/N 25328 N207ESPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020254 N207HVEuroaviation Inc Trustee · KematenBuilt 1978 · S/N 28R7803303 N207JUnwrapped LLC · Dover, DEBuilt 1965 · S/N P206-0086 N207LSNightbreak Aviation LLC · Houston, TXBuilt 1968 · S/N 680072 N207MAStreamline Aviation LLC · Battlefield, MOS/N 32-40923 N207MDGv Air Inc · Medford, ORBuilt 1976 · S/N 31-7612092 N207NEHylton Kyler E · Palmer, AKBuilt 1954 · S/N 31030 N207RPAllen Brent H · Mammoth Lakes, CAS/N 25-2009 N207VRB&C Properties LLC · Bristol, WIS/N 32-58 N207WWalters William L · Boise, IDBuilt 1963 · S/N 18254647 N207WTHenson Alan · Houston, TXBuilt 2000 · S/N E-3308 N207ZCBuha Holdings LLC · Paris, TXS/N E-3360 N207ZMInternational Air Services Inc Trustee · Carson City, NVBuilt 1993 · S/N TH1677 N20801Loveland Christopher K · Meridian, IDBuilt 1973 · S/N 18261216 N20803Goad Jimmy L · Bradford, ARBuilt 1972 · S/N 18261217 N20804Ceddia Stephen J · Framingham, MABuilt 1974 · S/N 17263841 N20805Welzenbach Craig L · Fair Oaks Ranch, TXBuilt 1972 · S/N 18261219

Back to AD 98-21-21 R1