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.

N2667WMartens Steven A · Stanley, NDBuilt 1966 · S/N 670024 N2668FBreaux Robert R · Chino Hills, CABuilt 1965 · S/N 18256768 N2668GGospel Ministries International · Mc Donald, TNBuilt 1959 · S/N 51968 N2668LEnnis Shannon E · Chesapeake, VABuilt 1967 · S/N 17255868 N2668RCummings Robert S · Bowling Green, KYBuilt 1967 · S/N 18258368 N2668TKing Thomas S · Boerne, TXBuilt 1971 · S/N 28-7205092 N2668UMid South Aircraft Inc · Gadsden, ALBuilt 1963 · S/N 17250268 N2668VPlane Fun Inc Tr Trustee · Snellville, GABuilt 1948 · S/N 18178 N2668WJarchow John H · Denison, TXBuilt 1966 · S/N 993 N26692Fields Douglas P Jr · Brooklyn, NYBuilt 1979 · S/N 310R1849 N2669FMichelbrink Hunter J · Gardiner, MTS/N 18256769 N2669LRotormate LLC · Royse City, TXBuilt 1967 · S/N 17255869 N2669QBanks Ron E · Blanchard, OKBuilt 1966 · S/N 18257869 N2669RStrubhar Wesley D · Foster, ORBuilt 1967 · S/N 18258369 N2669TCity Of Westfield · Westfield, MAS/N 28-7225082 N2669VMartin Brian J · Grayslake, ILBuilt 1948 · S/N 18179 N2669WAlecci Alexander Drew · Sanford, FLBuilt 1966 · S/N 994 N2669XSkydive Ricks LLC · Petersburg, OHBuilt 1965 · S/N P206-0169 N2669YHession Mark A · Arrington, TNBuilt 1962 · S/N 18051169 N266AAFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881760 N266ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496104 N266BNPinckney Michael M DBA · Pensacola, FLBuilt 1988 · S/N 89-301001 N266EASouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N TH-2031 N266FAStratus Rr LLC · New Castle, DEBuilt 2026 · S/N 28020262 N266GSchroeder Robert J · Kaukauna, WIBuilt 1966 · S/N TE-205 N266LCCambridge Aviation LLC · Hillsborough, NJBuilt 1966 · S/N 30-1157 N266MGGeorgia Aviation Authority · Eastman, GABuilt 2020 · S/N 2881364 N266PDLiberty Garden Center Inc · Norwich, NYBuilt 1967 · S/N D-8654 N266TCAir Control Systems · Bigfork, MTS/N EA-483 N266VFox Stephen A · Wasilla, AKBuilt 1954 · S/N 31215 N266WLowell James · Tucson, AZS/N 24-1923 N2670DBoggess William C · Placerville, CABuilt 1952 · S/N 20822 N2670LOns Bart · Kirkland, WABuilt 1967 · S/N 17255870 N2670MPhelan Construction LLC · North Andover, MABuilt 1986 · S/N CE-1082 N2670VRetro Air LLC · Seattle, WABuilt 1948 · S/N 18180 N2670YErickson Wesley B · Littleton, COBuilt 1962 · S/N 18051170 N2671CHouchen Chris F · Palmer, AKBuilt 1955 · S/N 35071 N2671LNbl Aviation LLC · Woodway, TXBuilt 1967 · S/N 17255871 N2671RCw Equipment Rentals Inc · Biggs, CABuilt 1967 · S/N 18258371 N2671UMetz Thomas H · Mifflintown, PABuilt 1963 · S/N 17250271 N2671WSchwister Daniel Edward · Woodinville, WABuilt 1966 · S/N 3315 N2672Reynolds Aviation LLC · Wills Point, TXBuilt 1992 · S/N E-2672 N2672CClipper Sky LLC · Las Vegas, NVS/N 35072 N2672FWright James F · Glenford, OHS/N 18256772 N2672GPhillips Douglas S · Gloversville, NYBuilt 1959 · S/N 51972 N2672MSchmoll Aviation LLC · Sterling, AKBuilt 1966 · S/N 18051729 N2672Q4m Aviation LLC · Orting, WABuilt 1977 · S/N 28R-7737040 N2672THilgendorf Blake W · Fairmont, MNBuilt 1971 · S/N 28-7110027 N2672UBender John Lowell Trustee · N Richland Hills, TXBuilt 1963 · S/N 17250272 N2672WGallatin Aviation Enthusiasts LLC · Fairbanks, AKBuilt 1966 · S/N 3316

Back to AD 98-21-21 R1