Registered aircraft · 85,616

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.

N121ESWell Bilt Industries USA LLC · Ocala, FLBuilt 1971 · S/N 28-7125383 N121FHamilton Wayne J · Mesa, AZBuilt 1956 · S/N 32353 N121FTBowman William K · Raleigh, NCBuilt 1982 · S/N 28-8216191 N121GBAviation Academy LLC · Wichita, KSBuilt 1968 · S/N 17257308 N121GHSunset Aviation LLC · Huntington, INBuilt 1977 · S/N 32R-7780262 N121GJ424 Ventures LLC · Saint Petersburg, FLBuilt 1976 · S/N TJ-62 N121HEJarrett Air LLC · Ashland City, TNBuilt 1979 · S/N 32-7940127 N121JRKlotz Geoffrey B · Moor Park, CABuilt 1977 · S/N 21061726 N121JTEffingham Eta LLC · Effingham, ILBuilt 2005 · S/N 3246231 N121KAAir Ally Asset Management LLC · Chisago City, MNS/N 17263836 N121KSCa-C180j LLC · Addison, TXBuilt 1976 · S/N 18052683 N121LATgl Inc · Wilmington, DEBuilt 1973 · S/N 310Q0973 N121LGPayton Kathleen · Grand View, IDBuilt 1964 · S/N TC-777 N121LLWild Blue Air LLC · Homer, AKBuilt 1977 · S/N U20603756 N121LMGolden Age N121lm LLC · Des Moines, IABuilt 2022 · S/N 2881529 N121MTc-Craft Aero Club Inc · Nampa, IDBuilt 1977 · S/N 18265624 N121MDBaggarly Michael · Newnan, GABuilt 1969 · S/N 28-25613 N121MSDarcy Aviation LLC · Danbury, CTBuilt 1978 · S/N 17271893 N121PEEggers Phillip S · Denton, TXBuilt 1983 · S/N EA-388 N121RAJohnson Owen M III · Seattle, WABuilt 1972 · S/N 18261660 N121RDVickery Forest H · Tallahassee, FLS/N 18052053 N121RJCessna 121 Rj LLC · Terra Bella, CABuilt 1972 · S/N 21059735 N121RLZaytsev Petr · Pflugerville, TXBuilt 1969 · S/N 690072 N121RWArbuckle Air LLC · Kansas City, MOBuilt 1970 · S/N CE-296 N121SClark William H IV · Thurmont, MDBuilt 1966 · S/N 32-835 N121SKRege Robert E · Cloverdale, CABuilt 1979 · S/N 24-0901 N121SLLadet David E · Lavonia, GABuilt 1969 · S/N 27-4475 N121TCDonney Tom J · Sturgis, SDBuilt 1978 · S/N 32-7840105 N121TFTorres Juan · Modesto, CABuilt 2004 · S/N 3257351 N121TWBlue Ridge Mountain Flyers Aviation LLC · Mineral Bluff, GABuilt 1977 · S/N 32R-7780301 N121WAWeather Modification LLC · Fargo, NDBuilt 1979 · S/N 34-7970435 N121WSOrtiz Ramon E · Spring Branch, TXBuilt 1978 · S/N 28R-7803340 N121YPNine Five Alpha LLC · Huntsville, ALBuilt 2000 · S/N E-3359 N1220Technical Education Services Inc T/A · Virginia Beach, VABuilt 1947 · S/N D-927 N12200Dunahoo Steven W · Cleveland, GABuilt 1973 · S/N 17261880 N12209Melendez Jesus · North Miami, FLS/N 17261881 N1220BWash Steven M · Austin, TXBuilt 1957 · S/N 23-1161 N1220CSky Bear Aviation LLC · Wilmington, DEBuilt 1956 · S/N 33008 N1220GGastrock Robert C Trustee · Anchorage, AKBuilt 1973 · S/N U20602232 N1220MMcginty Flying Service LLC · Jones, LABuilt 1975 · S/N 18264246 N1220XBuilding Enclosure Institute Inc · Hallandale Beach, FLBuilt 1963 · S/N 191 N1220ZColumbus State Community College · Columbus, OHBuilt 1959 · S/N 24-800 N12210Exclusive Motors Inc · Grand Prairie, TXBuilt 1973 · S/N 17261882 N12211Miller Todd B · Wayne, ILBuilt 1973 · S/N 17261883 N12212Wilson Donovan F · Friday Harbor, WABuilt 1973 · S/N 17261884 N12213Top Flight Aviation Inc · Corona, CABuilt 1973 · S/N 17261885 N12215Cm3 LLC · North Las Vegas, NVBuilt 1973 · S/N 17261887 N1221DJamison Tim · Oklahoma City, OKBuilt 1951 · S/N 19982 N1221KAirline Transport Professionals Corp Of USA · Wilmington, DES/N 44-7995295 N1221TOakley Scott S · Essex, MDBuilt 1970 · S/N 17259334

Back to AD 98-21-21 R1