Registered aircraft · 5,086

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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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.

N15498Universal Management And Mainteneance Co Inc · Enid, OKBuilt 1972 · S/N 32-7340010 N154BJDent Air Ltd · Annapolis, MDBuilt 1977 · S/N 32R-7780251 N154BZGrund Joseph R Jr · North Cape May, NJBuilt 1995 · S/N 27-0195 N154DCRocha Jonathan · Prescott Valley, AZBuilt 1969 · S/N 32-40599 N154WWAlpha Whiskey 1 LLC · Brandon, MSS/N 31-7952230 N15514Smedsmo Darrin A · Roseau, MNS/N 32-7340046 N1553XGreat Divide Aircraft LLC · Louisville, COBuilt 1975 · S/N 32R-7680003 N15552Crate Inc · Humboldt, NEBuilt 1972 · S/N 32-7340048 N15554Hogan James · Winter Garden, FLBuilt 1972 · S/N 32-7340014 N1556XMills Donald Lee · Arlington, TNBuilt 1975 · S/N 32-7540124 N155AEBissat Rashid H · Visalia, CABuilt 1989 · S/N 27-0014 N155EPGogoplex LLC · Wilmington, DEBuilt 1969 · S/N 27-4430 N1568WDfb Holdings LLC · Coeur D Alene, IDS/N T18208394 N15708Lanza Thomas N · Las Vegas, NVBuilt 1972 · S/N 32-7340058 N1572EKorkmaz Fethi A · Asheville, NCS/N 32-7340059 N1575XMaring Thomas J · Westley, CABuilt 1975 · S/N 32-7540178 N15776Rc & C Inc · Norwalk, IABuilt 1972 · S/N 32-7340064 N157CMChamark LLC · Knoxville, TNBuilt 1975 · S/N 32R-7680023 N1583XK&T Lawn & Landscape Inc · Newport News, VABuilt 1975 · S/N 32-7540179 N15895Ksgj Aircraft LLC · Saint Augustine, FLBuilt 1972 · S/N 32-7340072 N158TZBoney George C Jr Trustee · Chapin, SCBuilt 2000 · S/N 20037 N1591XTask Aviation LLC · Vancouver, WABuilt 1975 · S/N 32-7540180 N1594XPiper Flyers LLC · Zionsville, INBuilt 1975 · S/N 32R-7680004 N159BOppold Robert S · Overland Park, KSBuilt 1977 · S/N 27-7754047 N159DMLe Kenneth · Henderson, NVBuilt 2000 · S/N 2005 N15CASpirit Of Life Ministries International Inc · Carthage, TXBuilt 2005 · S/N 3257401 N15EASwanson Blake J · Ketchum, IDBuilt 2001 · S/N T20608333 N15FGShannon Jesse Lee · Boise City, OKBuilt 1975 · S/N 27-7554112 N15REGreat Alaskan Flooring Inc · Kodiak, AKBuilt 1968 · S/N 27-4068 N15SNRobinson Brian · Bedford, NHBuilt 2001 · S/N 25074C N15YPDepartamento De Educacion Prami · San Juan, PRBuilt 1968 · S/N 27-3966 N160XMalolo LLC · San Luis Obispo, CAS/N 500B-1300-115 N161BLAirborne Holdings Inc · Midlothian, TXBuilt 1965 · S/N 1551-197 N161MABarnes Gordon R · Manalapan, NJBuilt 2000 · S/N 3257161 N161MRVictor Aircraft Co · Wilmington, DEBuilt 1977 · S/N 27-7754106 N16253Quincy Aircraft LLC · Quincy, ILS/N 32-7340080 N16269Kelley John Charles · Hot Springs Ntl, ARBuilt 1973 · S/N 32-7340081 N1636PCorsnitz Bryan Scott · Huntington Beach, CABuilt 1978 · S/N 32R-7887228 N16372Blue Bird Aviation LLC · Zephyr Cove, NVBuilt 1973 · S/N 32-7340083 N163AWMccall Andrew Keith · Abilene, TXBuilt 2002 · S/N T18208163 N163DBDehghani Mohammad · Rolla, MOBuilt 2001 · S/N 3257210 N1640PBucher Max · Fort Mohave, AZBuilt 1978 · S/N 32R-7887221 N16415United Aviation LLC · Prospect, KYS/N 32-7340085 N164412c Fun Aviation LLC · Dallas, TXBuilt 1973 · S/N 32-7340087 N1646ZDmitry P Kudryn · Wasilla, AKBuilt 1962 · S/N 185-0446 N16487Piper Cherokee LLC · Seal Beach, CABuilt 1973 · S/N 32-7340090 N16498Owens Hay LLC · Crane, ORBuilt 1973 · S/N 32-7340091 N164JAgster Robert J · Fstrvl Trvose, PABuilt 1980 · S/N 32R-8029071 N1652NAllison Christopher · Cartersville, GABuilt 1999 · S/N 3257119 N16542Marianas Air Transfer Inc · Saipan, MPS/N 32-7340093

Back to AD 91-21-01 R1