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.

N1724RBlue Eagle Aviation LLC · Azle, TXS/N R18200536 N1724THanna David B · Tonasket, WABuilt 1964 · S/N 21058360 N1724YYankee Flying Club Inc · Maple Grove, MNBuilt 1977 · S/N 17268676 N1725CC Wolf Inc · Ord, NEBuilt 1953 · S/N 30425 N1725DBeisheim Carrie E · Fort Calhoun, NEBuilt 1951 · S/N 20168 N1725FWagner Harold D Jr · Hilltop Lakes, TXBuilt 1966 · S/N 17255120 N1725JNewton Mitchell W Sr · Huffman, TXFirst renewal noticeBuilt 1968 · S/N 28-24137 N1725MAirbach LLC · Irvington, KYBuilt 1975 · S/N 18264418 N1725TCarrell William G · Pittsburgh, PABuilt 1970 · S/N 28-7125036 N1725WEdwards John G · Stoneville, NCS/N D-9400 N1726RPetumenos Timothy J · Anchorage, AKBuilt 1974 · S/N 18502447 N1727CCarr Richard A · Boulder City, NVBuilt 1954 · S/N 30427 N1727DHall L Robert · La Verne, CAS/N 20170 N1727FWhetham Ed · Wilton, NDBuilt 1966 · S/N 17255122 N17281Martin Air LLC · Fort Wayne, INBuilt 1960 · S/N 50774 N17286Pride Terence E · Columbia, TNS/N 32-40899 N1728CMasek Lawrence J · Cuyahoga Falls, OHBuilt 1953 · S/N 30428 N1728FLemmon Mark D · Heppner, ORBuilt 1963 · S/N 17250887 N1728GMeyer Fred F · Hampshire, ILBuilt 1962 · S/N D-6946 N1728HTn Millworks LLC · Mt Juliet, TNS/N 28-7716047 N1728JHogan Thomas A · Fairfield, OHS/N 28-24140 N1728MAnderson Michael · Missoula, MTBuilt 1975 · S/N 18264419 N1728RIcenogle Roger A · Inver Grove, MNBuilt 1974 · S/N 18502449 N1729CN8969v LLC · Anchorage, AKBuilt 1953 · S/N 30429 N1729FAllmann Mark F Trustee · Kent, WABuilt 1954 · S/N 30619 N1729YFlying Colors Airparts Inc · Leesburg, FLBuilt 1978 · S/N 17270229 N172APocock Milne David · Cal Nev Ari, NVBuilt 1961 · S/N 172-48797 N172AAStuart S Macpherson Dds Inc · Cardiff By The Sea, CABuilt 1954 · S/N 30757 N172ADRust Michael David · Rush City, MNBuilt 1969 · S/N 17258365 N172AKGazarek Edward · Fort Myers, FLBuilt 1967 · S/N 17255914 N172AMYang Chi · Lafayette, COBuilt 1975 · S/N 17264993 N172APBmac Aviation LLC · Dallas, TXBuilt 1976 · S/N 17266592 N172ARStraub Cordaro · Monterey, CABuilt 1975 · S/N 17266174 N172ATFulco Flyers Club Inc · Cobleskill, NYBuilt 1979 · S/N 17272693 N172BTorres Marie Ivette · Corpus Christi, TXBuilt 1977 · S/N 17269593 N172BACarrolls Auto And Aircraft Sales LLC · Muncie, INS/N 17259091 N172BCSlayton Jeffrey W · Prospect, TNBuilt 1963 · S/N 17250914 N172BEAero Northwest LLC · Port Angeles, WABuilt 1971 · S/N 17259668 N172BHWright Charles L · Kirkland, WABuilt 1964 · S/N 17251670 N172BKUsaeroflight LLC · Greenville, SCBuilt 1976 · S/N 17267323 N172BLMullinax Donald D · Graham, WABuilt 1974 · S/N 17262050 N172BMBarrett Jacob D · Paris, ILBuilt 1968 · S/N 17256780 N172BNRedtail Aviation LLC · Rexburg, IDBuilt 1966 · S/N 17254846 N172BROc Flight Lessons LLC · Costa Mesa, CABuilt 1975 · S/N 17265776 N172BSNothing Wasted LLC · Bunker Hill, INBuilt 1972 · S/N 17260390 N172BTBroderick Edward P · Halifax, MABuilt 1970 · S/N 17258936 N172BXBas Part Sales LLC · Greeley, COBuilt 1966 · S/N 17254216 N172CACalifornia Airways LLC · Hayward, CABuilt 1978 · S/N 17270629 N172CCWings Over Texas Holdings LLC · Denton, TXBuilt 1971 · S/N 17260031 N172CDHnh Enterprises Inc · Lander, WYBuilt 1964 · S/N 17252386

Back to AD 98-21-21 R1