Registered aircraft · 85,612

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.

N287BLBlue Line Aviation LLC · Smithfield, NCBuilt 2024 · S/N 2881750 N287BWDaniels Kelly M · Humble, TXBuilt 1979 · S/N R18201329 N287DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843826 N287DPMag Aviation LLC · Carl Junction, MOBuilt 1978 · S/N 32R-7885204 N287GE7ge Aviation LLC · Southfield, MIFirst renewal noticeBuilt 1964 · S/N 30-522 N287HHaught Herbie B Jr · Mountain View, ARBuilt 1965 · S/N D-7763 N287HGGeorgia Aviation Authority · Eastman, GABuilt 2002 · S/N 2842145 N287JGGully John F · Brooklyn, NYBuilt 1965 · S/N CD934 N287KMO'Connor Thomas F · Plano, TXBuilt 1980 · S/N TJ-330 N287LMDjc Bonanza LLC · Stuart, FLBuilt 1994 · S/N E-2859 N287NDSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2844036 N287PN8297n LLC · Evansville, INBuilt 1968 · S/N 28-24806 N287PASkywest Leasing Inc · St George, UTBuilt 2002 · S/N 4496110 N287TCAiv Con Inc · Charlevoix, MIBuilt 1969 · S/N 18260183 N287VCGreat Sky LLC · Brooklyn, NYBuilt 1979 · S/N 28-7911231 N2880CBuchert Allen C · Grand Rapids, MNBuilt 1954 · S/N 26423 N2880EDemulling Michael C · New Richmond, WIBuilt 1978 · S/N 17271358 N2880LLucas Shane Andrew · Spencer, WVS/N 28-7911222 N2880NRoth Harry · Pittsburgh, PAS/N 28-7911223 N2880RPhelps Thomas J · Orem, UTBuilt 1967 · S/N 18258480 N2880TVuppala Kavya · Springtown, TXBuilt 1972 · S/N 28R-7235151 N2880YRegistered aircraftBuilt 1962 · S/N 18253880 N2881ABarnhart Ian · Wrightsville, PAS/N 28-7911224 N2881CCompton Steven · Anchorage, AKBuilt 1954 · S/N 26424 N2881FAirplanes Over Niagara LLC · Lewiston, NYBuilt 1966 · S/N 18256981 N2881GGardocki Joseph E · Oklahoma City, OKBuilt 1979 · S/N 32-7940177 N2881LCore Alan L · Indianola, IABuilt 1967 · S/N 17256081 N2881MJones James N · Missoula, MTBuilt 1977 · S/N 28R-7803153 N2881QNeenah Aircraft Leasing LLC · Neenah, WIBuilt 1971 · S/N 17259881 N2881ZHoag Peter J · Arlington Heights, ILBuilt 1979 · S/N 32-7940181 N2882BDriscoll Wallace Brock · Aberdeen, IDBuilt 1979 · S/N 28-7921051 N2882CG & M Aircraft Inc · Wheat Ridge, COBuilt 1979 · S/N 44-7995302 N2882RPostlewait Logging Co · Port Allegany, PABuilt 1969 · S/N 28R-35317 N2882TParis Air Inc · Vero Beach, FLBuilt 1972 · S/N 34-7250180 N2882WWholey James · Saratoga, CABuilt 1973 · S/N E-452 N2882YVx Aviation LLC · Palisade, COBuilt 1962 · S/N 18253882 N2883NPeters Mark E · Newport News, VAFirst renewal noticeS/N 34-7970325 N2883RCallegari Sergio P · Reno, NVBuilt 1967 · S/N 18258483 N2883TGolembiewski William · Hookstown, PABuilt 1972 · S/N 28-7225265 N2883UPaul Aviation LLC · Sault Sainte Marie, MIBuilt 1963 · S/N 17250483 N2883YNimmo Philip · Bishop, CAS/N 34-7970327 N28842Turnquest Joad · Sanford, NCBuilt 1979 · S/N 28-7916417 N28849Roonie Inc · Wilmington, DES/N 310Q0036 N2884ADowns M Todd · De Leon, TXFirst renewal noticeBuilt 1953 · S/N 30084 N2884CKuehn Wilton H III · Turtle Lake, NDBuilt 1954 · S/N 26427 N2884DThree Wing Flight School LLC · Stratford, CTBuilt 1979 · S/N 28-7916504 N2884FTurner Michael B · Covington, TNBuilt 1966 · S/N 18256984 N2884KJ Robert Finley And Associates Inc · Mountain Home, ARBuilt 1979 · S/N 18053118 N2884LPurdue Aviation LLC · West Lafayette, INBuilt 1979 · S/N 28-7916507 N2884MWattum Investments LLC · Kodiak, AKBuilt 1977 · S/N 32-7840058

Back to AD 98-21-21 R1