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.

N2461QJessi Air Ltd · West Salem, OHBuilt 1977 · S/N 28-7790399 N2461RFx Mining LLC · Haines, AKBuilt 1964 · S/N 18255561 N2461UHansen Aviation LLC · Savannah, GABuilt 1963 · S/N 17250061 N2461XBallard Devin J · Quail, TXBuilt 1965 · S/N 18256361 N2461YIbx Living LLC · Wake Forest, NCBuilt 1962 · S/N 17249761 N2462EFive Six Zero One LLC · Orange, CABuilt 1978 · S/N 17271291 N2462LSneed Associates LLC · Fort Morgan, COBuilt 1966 · S/N 17255662 N2462RTrade Winds Aviation Holdings LLC · Lewes, DEBuilt 1969 · S/N 28-5628 N2462UBixler Timothy · Wildwood, FLS/N 17250062 N2463CWofford Johnny A · Fort Davis, TXBuilt 1963 · S/N 17250569 N2463ULively Matt E · Aledo, TXBuilt 1963 · S/N 17250063 N2463YCaylin LLC · Wilmington, DEBuilt 1962 · S/N 17249763 N2464QWilson Jeff · White Bluff, TNBuilt 1977 · S/N 28R-7737035 N2464RStoffers William · Samoa, CABuilt 1964 · S/N 18255564 N2464UFly By Faith LLC · Laurel Springs, NCBuilt 1963 · S/N 17250064 N2464WOktela Steven L · Melbourne, FLS/N 3213093 N2464YHogan Dale R · Monterey, CABuilt 1962 · S/N 17249764 N2465CToal Timothy R · Milan, ILBuilt 1954 · S/N 30765 N2465ELeal Felipe · Missouri City, TXBuilt 1978 · S/N 17271292 N2465GMunson Darrel L · Ogallala, NEBuilt 1959 · S/N 51765 N2465RDarrow Brett · Minerva, NYS/N 28-5629 N2465XK4 Land And Grain Co · Lothair, MTBuilt 1965 · S/N 18256365 N2466EMarkham Dean F Jr · Greenville, NCBuilt 1978 · S/N 17271293 N2466QWentworth Douglas G · Simpsonville, KYBuilt 1966 · S/N 18257666 N2466RToland Beldon T · Dodge City, KSBuilt 1964 · S/N 18255566 N2466UHolloway Andrew · David City, NEBuilt 1963 · S/N 17250066 N2467DKaras Alyssa · Henderson, NVBuilt 1952 · S/N 20619 N2467FTherkelsen Robert D · Burlington, WABuilt 1966 · S/N 18051669 N2467GShort David J · Warrensburg, MOBuilt 1959 · S/N 51767 N2467LPatton Michael D · Tygh Valley, ORBuilt 1966 · S/N 17255667 N2467RSparks Eric D · Missouri Valley, IABuilt 1964 · S/N 18255567 N2468BRegistered aircraftBuilt 1970 · S/N 18260274 N2468CHatley Ralph A · Eagle Creek, ORBuilt 1954 · S/N 30768 N2468EUrbany Mark A · Hickory, PABuilt 1978 · S/N 17271294 N2468JJh Investments LLC · Henderson, NVBuilt 1996 · S/N 24-3391 N2468LCavender Kevin S · Tucson, AZBuilt 1966 · S/N 17255668 N2468RCruson Dale E Trustee · Ontario, ORBuilt 1964 · S/N 18255568 N2468TMackie Robbie L · Murfreesboro, TNBuilt 1971 · S/N 28-7225074 N2468URegistration Pending · Washington, WVRegistration pendingBuilt 1963 · S/N 17250068 N2469DPierce Jerri L · Ozona, TXBuilt 1952 · S/N 20621 N2469QKepler Jason M · Wasilla, AKBuilt 1966 · S/N 18257669 N2469RKrehbiel Doug W · Moscow, IDBuilt 1964 · S/N 18255569 N2469XFraulini Michael M · Franklin Furnace, OHBuilt 1965 · S/N 18256369 N2469YStanphill David L · Stephenville, TXBuilt 1962 · S/N 17249769 N246ADBialas Robert E II · Fort Worth, TXBuilt 1968 · S/N 28R-30423 N246ALAiror LLC · Lees Summit, MOBuilt 1978 · S/N E-1412 N246ATBorghi Eric C · Leonia, NJBuilt 1989 · S/N 24-3121 N246AZRegistered aircraftBuilt 1983 · S/N 28-8311025 N246BGuynn Dane L · Peachtree City, GAS/N 310K0030 N246BBTruman Nissley · Moberly, MOBuilt 1978 · S/N 24-0752

Back to AD 98-21-21 R1