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.

N2348QLegha Jaskirat · Holly Ridge, NCBuilt 1998 · S/N TH-1848 N2348RMiller Robert S · Laurel Springs, NCBuilt 1964 · S/N 18255448 N2348UWojnar Ronald T · East Troy, WIBuilt 1962 · S/N 17249948 N2348XChessman H Ross · Erie, COBuilt 1965 · S/N 18256248 N2349CSchwend Brian · Forsyth, MTBuilt 1953 · S/N 30649 N2349DFedorka Paul R Trustee · Soldotna, AKBuilt 1952 · S/N 20501 N2349FMilutinovic Christain · Marengo, ILBuilt 1964 · S/N 21058549 N2349GRegistration Pending · Buckley, WARegistration pendingBuilt 1958 · S/N 51649 N234ATr Aero LLC · Poway, CABuilt 1972 · S/N TC-1437 N234ABBachteal Paul Shear · Sebastopol, CABuilt 1991 · S/N CE-1562 N234AJMullins Land Co Inc · Aiken, SCBuilt 1995 · S/N 3246008 N234ALDale James H · La Vernia, TXS/N D-4457 N234APOrr Lynn E · Fredericksburg, OHBuilt 1988 · S/N CE-1232 N234BGLangeland Thomas Arthur · San Antonio, TXBuilt 1965 · S/N 30-909 N234BPYoung Tim M Trustee · Edmond, OKBuilt 1992 · S/N 24-3283 N234BWWaring Marvin Barton · Anacortes, WABuilt 1979 · S/N P21000290 N234CEAir Arctic Inc · Fairbanks, AKBuilt 1980 · S/N 31-8052203 N234CMTallman Donald Depaul · Venice, FLBuilt 1966 · S/N 18257696 N234CPZan Am LLC · Findlay, OHBuilt 2000 · S/N 28-43369 N234DDNunez Christian · Grand Prairie, TXBuilt 1973 · S/N 73-30528 N234DHCarrell Evan Paul · Queen City, TXBuilt 1969 · S/N D-8966 N234DLAngel Wings LLC · Waxhaw, NCFirst renewal noticeBuilt 1983 · S/N 32R-8329029 N234DWN234dw Aviation Inc · Okemos, MIBuilt 1974 · S/N 310R0008 N234EBArbuckle James H · Bellevue, NEBuilt 1966 · S/N D-8157 N234FNelson Graig M · Eastsound, WABuilt 1955 · S/N 32142 N234FYVee Two Inc · Merritt Island, FLBuilt 1978 · S/N 347870428 N234GAAllen Dean C II · Green Sea, SCBuilt 1967 · S/N 680036 N234GLL J Aircraft LLC · Cedar City, UTBuilt 1966 · S/N CE-112 N234GMCunningham Hal A · Standard, CABuilt 1976 · S/N 17266438 N234GTAny Border LLC · Yankton, SDBuilt 1977 · S/N 21062155 N234HWestphal Ronald R · Aurora, ILBuilt 1954 · S/N CH-133 N234JCL&L Air LLC · Cave Creek, AZBuilt 1976 · S/N 28-7715093 N234JEAimrich Enterprises · Wilmington, DEBuilt 1987 · S/N CE-1193 N234JFInternational Air Services Inc Trustee · Carson City, NVS/N 32R-7887265 N234JGBartlett William F · Jackson, WYBuilt 1975 · S/N 17265225 N234JPBistline Worth · New Harmony, UTS/N 25-0277 N234JSOcean Blue Aviation LLC · Farmingdale, NYBuilt 1976 · S/N 18502956 N234KMMurray Edward L · Hoover, ALS/N 28-7990043 N234MGDubin Wayne M Trustee · Fort Myers, FLBuilt 1977 · S/N TE-1104 N234MPBaugher Gregory V · Hannibal, MOBuilt 1968 · S/N 680183 N234MWKuehn Kevin C · De Pere, WIBuilt 1964 · S/N 310I0034 N234NCIal Corp · Lewes, DEBuilt 1973 · S/N 34-7350146 N234PAJuliet Two LLC · Ocean Ridge, FLBuilt 1978 · S/N 28-7816677 N234PKHintz Courtney N · San Antonio, TXBuilt 1963 · S/N 18254645 N234PTJaguar Management Group LLC · Wilmington, DEBuilt 2000 · S/N EA-662 N234PWRight Rudder LLC · Sapulpa, OKBuilt 1978 · S/N 18266103 N234QASteinke Mark · Camas, WABuilt 1959 · S/N 52409 N234RBMoyer Thomas L · Fayetteville, GABuilt 1976 · S/N TC-1950 N234RCRonnie G Crider Pa · Clearwater, FLBuilt 1985 · S/N R18202012 N234RMWilliams Walt A · Mena, ARBuilt 1964 · S/N 17252230

Back to AD 98-21-21 R1