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.

N1484TPolasik Julia Suzanne · Victor, IDBuilt 1972 · S/N 28-7225531 N1484UCrescent City Aviation Club LLC · New Orleans, LABuilt 1976 · S/N 17267151 N1484XAlpha-One Air Service LLC · Concord, NCBuilt 1975 · S/N 28-7505233 N1484YHarrison Dennis N · New London, MOS/N 17249184 N1485GHarris John F III · Louisburg, NCBuilt 1962 · S/N D-6933 N1485SMitchell Daniel P · Marseilles, ILBuilt 1976 · S/N 18265032 N1485UClass A Aviators Inc · Parsons, KSBuilt 1976 · S/N 17267152 N1485XBond Bryce W · Chandler, AZBuilt 1975 · S/N 28R-7535290 N1486GDrennan Monte D · Caddo, OKBuilt 1962 · S/N CD-475 N1486HLynn John · Coffee Creek, MTS/N 28-7716026 N1486MBrewer Donald S · Paragould, ARBuilt 1975 · S/N 18264349 N1486SBurdine Aviation Inc · Glidden, IABuilt 1976 · S/N 18265033 N1486TSpivey Darwyn D · Guntersville, ALBuilt 1972 · S/N 28-7225533 N1486UMoss Motor Company Inc · South Pittsburg, TNBuilt 1976 · S/N 17267153 N1486XMidwest Investment Corp · Griffith, INS/N 28R-7535291 N1486YPost Greg · Fort Scott, KSBuilt 1962 · S/N 17249186 N14872Blumenthal James R · Kingman, AZBuilt 1973 · S/N U20602144 N1487SSkovira Michael D · Scottdale, PABuilt 1976 · S/N 18265034 N1487TFalcon Flying Club LLC · Fayetteville, GABuilt 1972 · S/N 28-7205307 N1487UNew Richard A · Deming, WABuilt 1976 · S/N 17267154 N1487VFirst Flight Corporation · San Diego, CABuilt 1974 · S/N 17263621 N1488HDeplazes Anthony · Rugby, NDS/N 28-7716027 N1488UShine Donald J · Waterford, WIBuilt 1976 · S/N 17267155 N1488VPerks Brian G · Otis Orchards, WAS/N 17263622 N1489DAce Hole Flying Club LLC · Spokane, WABuilt 1951 · S/N 20091 N1489EWings Over Water Inc · Minneapolis, MNBuilt 1978 · S/N 17271019 N1489FHoover Andrew V · Jenison, MIBuilt 1966 · S/N 17254984 N1489MBrinker Corp Inc · Glen Elder, KSBuilt 1975 · S/N 18264350 N1489SBender Roger J · Overgaard, AZBuilt 1976 · S/N 18265036 N1489TLion Aviation LLC · Kansas City, MOBuilt 1972 · S/N 32-7200042 N1489UAustin Aeroflight Inc · Austin, MNBuilt 1976 · S/N 17267156 N148AParagon Flight Training Co · Fort Myers, FLBuilt 2025 · S/N 28020203 N148DSEast Ramp Aviation LLC · Baton Rouge, LABuilt 1986 · S/N TH-1439 N148FCDepartment Of Agriculture & Consumer Scvs · Tallahassee, FLBuilt 2022 · S/N 2881520 N148GMorrill William I · Kerrville, TXBuilt 1979 · S/N 18267097 N148JBBell Jason W · Flower Mound, TXBuilt 1979 · S/N 18266827 N148KMRstl LLC · Minster, OHS/N 28-7990342 N148LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842191 N148PFMacallen Chemical Inc · Monroe, LABuilt 1978 · S/N 34-7970017 N148PRJaspar Dorsey E · Bakersfield, CABuilt 1967 · S/N D-8580 N148RFPaklook Air Inc · Bethel, AKFirst renewal noticeBuilt 1976 · S/N 32R-7680076 N148SBGriner Warren D · Pinson, ALBuilt 1966 · S/N 30-1148 N148TTBoard Of Trustees Western Michigan University · Battle Creek, MIBuilt 2018 · S/N 4496428 N148TXRegistration Pending · Austin, TXRegistration pendingBuilt 1979 · S/N 18267500 N148UUpmeyer Matthew D · Richland, WABuilt 1967 · S/N D-8437 N14908Reiter Scott D · Leesburg, VABuilt 1974 · S/N 74-30662 N14909Johnson Bruce M · Schertz, TXBuilt 1973 · S/N 74-30626 N1490DCole Daniel G · Pittsburgh, PAS/N 20092 N1490EFoothill Aircraft Sales & Service Inc · Upland, CABuilt 1978 · S/N 17271020 N1490GSmith David Brian · Indianapolis, INBuilt 1962 · S/N CD-476

Back to AD 98-21-21 R1