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.

N2275KSutton Aircraft Salvage LLC · Palmer, AKS/N 51163 N2275LN2275l LLC · Ball Ground, GABuilt 1976 · S/N D-9945 N22760Tuskegee Airmen National Historical Museum · Detroit, MIS/N 28-7425211 N22763Horstick Thomas E · Garnett, KSS/N 28-7425213 N2276CLeading Edge Consulting LLC · Mitchell, SDBuilt 1976 · S/N CE672 N2276GRegistration Pending · Salt Lake City, UTRegistration pendingBuilt 1958 · S/N 51576 N2276MMuddy River Capital LLC · Glendive, MTBuilt 1977 · S/N 28R-7803119 N2276SBogaudo Robert J · Vulcan, MIBuilt 1979 · S/N R18201318 N2277DTaking Flight LLC · Saint Augustine, FLBuilt 1974 · S/N 28-7425225 N2277FEagle Mission LLC · Keystone Heights, FLBuilt 1956 · S/N 35352 N2277QComanche Aviation LLC · Chanute, KSBuilt 1977 · S/N 28R-7703060 N2277SSimmons Matthew Steven · Port Orange, FLBuilt 1979 · S/N R18201319 N2277VN2277v LLC · Mesa, AZBuilt 1975 · S/N 28-7525188 N2277YSheffield Richard Lee · Los Alamos, NMBuilt 1972 · S/N 18261225 N2279GParker Robert M · Hurst, TXBuilt 1958 · S/N 51579 N2279RLehmann Albert F II · Simpsonville, SCBuilt 1969 · S/N T210-0429 N2279TRegistration Pending · Lakeville, MNRegistration pendingBuilt 1971 · S/N 28R-7135181 N227AKHanzawa George K · Wahiawa, HIBuilt 1981 · S/N 31-8152198 N227ALGarbar Organization LLC · Duncan, SCBuilt 1975 · S/N 34-7670028 N227BChase 13 LLC · Wilmington, DEBuilt 1956 · S/N D-4467 N227BRSchoo Michael J Trustee · Ridgway, COBuilt 1977 · S/N TK-31 N227BYAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1970 · S/N TC-1347 N227CARa Procurement LLC · Helena, MTS/N 27-4591 N227CMMmkb Inc · Wilmington, DEBuilt 1976 · S/N 18264533 N227DKirkland Daniel · Kingman, AZBuilt 1976 · S/N 21061540 N227DSL & P Air LLC · Lees Summit, MOBuilt 1957 · S/N FH-74 N227ECEcjet Inc · Downey, CABuilt 1974 · S/N 31-7405184 N227EMVisceral Technologies LLC · Yulee, FLBuilt 2001 · S/N 3257208 N227FBAtlantic Flying Club Inc · Fernandina Beach, FLBuilt 1979 · S/N 17272654 N227JKMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881537 N227MSkyway Partners · Woodside, CABuilt 1964 · S/N 17251565 N227MWWatson Michael Timothy · Granbury, TXBuilt 1974 · S/N D-9682 N227PQMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881544 N227QHanke Peter W · Chimacum, WABuilt 1964 · S/N D-7523 N227RFHouser Harry David Jr · Williamstown, WVBuilt 1972 · S/N 327200045 N227RGLearn To Fly In Central Arkansas LLC · Searcy, ARBuilt 1974 · S/N 27-7554021 N227RMHeli Coral Inc · Wilmington, DEBuilt 1979 · S/N 31-7912085 N227SSRiver Front Akn LLC · Anchorage, AKBuilt 1970 · S/N U20601516 N227XYMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881571 N2280BDream Flight Aviation LLC · New Fairfield, CTBuilt 1982 · S/N TH-1344 N2280QJaz One Holdings Inc · Farmingdale, NYS/N 28-7716095 N2280RRusso John · Seaside, CAS/N T210-0430 N2280TRegistered aircraftBuilt 1977 · S/N R18200016 N2281FClassic Air Aviation LLC · Mesa, AZBuilt 1967 · S/N 310L-0081 N2281GBurriss James E Jr · Piedmont, SCBuilt 1958 · S/N 51581 N2281QFreeman Michael J · Chillicothe, OHBuilt 1977 · S/N 28-7716096 N2281TAvpac Insurance Services Inc · Santa Ana, CABuilt 1977 · S/N R18200017 N2282DStandhart Gary S · Wickenburg, AZBuilt 1952 · S/N 20434 N2282FSjoblom Donald W · Maple Grove, MNBuilt 1967 · S/N 310L-0082 N2283LMoser Jerald L · Tucson, AZS/N D-9948

Back to AD 98-21-21 R1