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.

N2715UBelle Fourche Flight Center LLC · Belle Fourche, SDBuilt 1963 · S/N 17250315 N2715YEmerson Michael J · Athens, ALBuilt 1958 · S/N TD-62 N2716DDammann Willa B · Murrieta, CABuilt 1952 · S/N 25258 N2716WBig Sky Aviation LLC · Meridian, IDBuilt 1966 · S/N 1025 N2716XShaw Brandon L · Juneau, AKBuilt 1965 · S/N 18051516 N2717AMitchell Matthew · Roanoke, TXBuilt 1969 · S/N D-9049 N2717CGibboney Scott H · Temecula, CABuilt 1954 · S/N 26261 N2717DGrimsley Steve K · Underhill, VTBuilt 1953 · S/N 25259 N2717GKlotz Terrance M · Sparks, NVBuilt 1959 · S/N 52017 N2717TIberlin James M · Gillette, WYBuilt 1967 · S/N TE-351 N2717URasmussen Raleigh C · Seattle, WABuilt 1963 · S/N 17250317 N2717VBlazek James T · Malta, ILBuilt 1947 · S/N D-93 N2718AOmega2alpha Services LLC · Brock, TXBuilt 1969 · S/N CD-1231 N2718DCongdons Aviation Service · Anchorage, AKBuilt 1952 · S/N 25260 N2718FJackalope Flyers LLC · Whitefish, MTBuilt 1965 · S/N 18256818 N2718QJenerette Marcus · Galivants Ferry, SCBuilt 1967 · S/N 18257918 N2718UBondurant Ross · Eugene, ORBuilt 1963 · S/N 17250318 N2718XPoirier Theodore N · Biddeford, MEBuilt 1965 · S/N 18051518 N2719CBrown Kevin Charles · Round Rock, TXBuilt 1977 · S/N 28R-7803034 N2719DRaber Michael R · Xenia, OHFirst renewal noticeBuilt 1952 · S/N 25261 N2719FSjoblom Erik Anders · Washington Twp, MIBuilt 1966 · S/N 18256819 N2719RJenkins Bruce D · New Market, MDBuilt 1969 · S/N 28R-35265 N2719UVilches Armando L · Brentwood, TNBuilt 1963 · S/N 17250319 N2719WNance Russell · Pelion, SCBuilt 1966 · S/N 1026 N271AGPeregrine Howard Aeroflight Owner LLC · New Orleans, LABuilt 2025 · S/N 2881989 N271AMMonthy Christian · Van Nuys, CABuilt 1973 · S/N 17262510 N271ASSkattum LLC · Sioux Falls, SDBuilt 1976 · S/N 31-7612073 N271EARichardson Cotton Inc · Wilmington, DES/N E-3486 N271GArcher Aero LLC · Wilmington, DEBuilt 2019 · S/N 2881114 N271GTBroulik Robert L · Lisbon, IABuilt 1976 · S/N 17267114 N271HWHot Wings Aviation LLC · Fishers, INBuilt 2026 · S/N 28020271 N271MDDismore Matthew · Gulfport, MSBuilt 1979 · S/N 32-7940232 N271MGGeorgia Aviation Authority · Eastman, GABuilt 2021 · S/N 2881453 N271PBClark Mayer Aviation LLC · Cross Roads, TXBuilt 1997 · S/N TH-1840 N271REEigsti Rodney E Trustee · Friend, NEBuilt 1960 · S/N 47227 N271RGCapitol City Flyers Inc · Madison, WIBuilt 1978 · S/N R18200528 N271SBowker Mark · Bowdoinham, MEBuilt 1974 · S/N TC-1791 N271SGCoco Aircraft Inc · Merritt Island, FLBuilt 2000 · S/N 28-42071 N2720ABaron N2720a LLC · Faulkton, SDBuilt 1978 · S/N TK-69 N2720DHill Sheldon S · Minot, NDBuilt 1952 · S/N 25262 N2720EAmerican Patrols Inc · Midland, TXBuilt 1978 · S/N 17271305 N2720GGenstler Jeremy A · Apple Valley, CABuilt 1959 · S/N 52020 N2720LBaalman Gary E · San Jose, CABuilt 1967 · S/N 17255920 N2720QDelta Yankee Aviation LLC · Anguilla, MSBuilt 1967 · S/N 18257920 N2720TMiller Mark · Bellevue, WABuilt 1967 · S/N D-8441 N2720WSharbono Dennis E · Billings, MTBuilt 1966 · S/N 1027 N2720XStubbs John C · Bangor, MEBuilt 1965 · S/N 18051520 N2721QN2721q LLC · Stuart, FLBuilt 1967 · S/N 18257921 N2721TGalvin Peter · Laytonsville, MDBuilt 1967 · S/N D-8443 N2722AMontgomery Douglas Tanner · San Antonio, TXBuilt 1969 · S/N D-9050

Back to AD 98-21-21 R1