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.

N182BZBaker John J · Tucson, AZBuilt 1982 · S/N R18201878 N182GMBaker Charles W · Lake Worth, FLBuilt 2005 · S/N 18281635 N182GNWorthington Greg · San Francisco, CABuilt 2002 · S/N T18208112 N182HFCook Daniel E · Gulf Breeze, FLBuilt 2005 · S/N 18281586 N182HZElings Heath R · Conrad, MTBuilt 2002 · S/N T18208129 N182JZMercer Fraser Co · Eureka, CABuilt 2004 · S/N T18208258 N182LKEllison William G · Telluride, COS/N T18208182 N182MGTurnidge Austin Michael · Seattle, WABuilt 2001 · S/N T18208046 N182MUTru Flight Materials LLC · Wilmington, DEBuilt 2004 · S/N T18208334 N182PMRg Aviation LLC · Fulton, MSBuilt 2004 · S/N 18281330 N182PPPatch Patricia A Trustee · Titusville, FLBuilt 2005 · S/N T18208389 N182TSLynch Larry E · West Branch, IABuilt 2004 · S/N T18208237 N182WNTyson Stephen E · Marion, IABuilt 2001 · S/N T18208061 N18311Begay & Away LLC · Houston, TXS/N 32-40092 N1834UWirth Rodney A · Greenwood, ARBuilt 2005 · S/N T20608546 N183MKRude Daniel · Leesburg, VAS/N T18208341 N1851APlacer County Sheriffs Department · Auburn, CABuilt 1977 · S/N 31-7812030 N186Sold Now Development LLC · Boca Raton, FLBuilt 1980 · S/N 32-8024026 N1860HNighthawks Sanity LLC · Chesterfield, MOBuilt 1977 · S/N 32-7740043 N1861HElusive Aviation Inc · Pflugerville, TXBuilt 1977 · S/N 32R-7780195 N1862HKaufman Keith · Reading, PABuilt 1977 · S/N 32R-7780196 N1872EAmerican Valet Air Inc · Wilmington, DEBuilt 1980 · S/N 31-8052114 N1872HDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 31-7652053 N187GJerchau Ryan P · Bellmore, NYBuilt 1978 · S/N 32R-7887235 N187TCRiesenberg Tyson Robert · Bountiful, UTBuilt 2001 · S/N 3257261 N1888EChoe Young Kyu · Manhasset, NYBuilt 1999 · S/N 1888 N188ABSafford Aviation Service Inc · Coolidge, AZBuilt 1969 · S/N 32-40884 N188LAAvf Flyers LLC · Richmond, VAS/N 4636185 N188SEChernov Boris · Lima, OHBuilt 1978 · S/N 32R-7885255 N188SPThornado Aviation LLC · Indialantic, FLBuilt 1977 · S/N 32R-7780309 N189GTKenai Aviation LLC · Akron, OHBuilt 2001 · S/N 2022 N189MHSpirit Life Inc · Morrison, COBuilt 1998 · S/N 4636159 N189MJBarnes Aviation LLC · Flowood, MSBuilt 2004 · S/N 3257340 N189RPElferdink Steven · Naples, FLBuilt 2006 · S/N 3257410 N18HLBusinessliner Inc · Ft Lauderdale, FLBuilt 1980 · S/N 31-8052055 N18JMDixon John F · Hayden, IDBuilt 1999 · S/N 4636229 N18LHKrystal Sky Aviation LLC · Melbourne, FLBuilt 1998 · S/N 32-57058 N18RJDocs Air LLC · Diamondville, WYS/N 27-4382 N1903SGriffin Products Inc · Wills Point, TXBuilt 1999 · S/N 1903 N1906HTriplett Gregory L · Holden, MOBuilt 1977 · S/N 32R-7780199 N1908HSandlin James B · Surgoinsville, TNBuilt 1977 · S/N 32R-7780201 N190AVNghiem Daniel · Westminster, CAS/N 2165 N190PHJohnson Cameron M · Worthington, MNBuilt 1977 · S/N 32-7740064 N190TATuck Aerial Surveys Inc · Big Stone Gap, VABuilt 1980 · S/N 31-8012040 N1918TThompson Todd · Elmore, MNBuilt 1971 · S/N 32-7140060 N19194Smokey Bear Air LLC · Cascade Locks, ORBuilt 2005 · S/N T18208428 N191FAHarvey Taz E · Danville, CABuilt 2003 · S/N T18208191 N191RAnderson Harold E · Phoenix, AZBuilt 1955 · S/N 35229 N191RVSpurgeon Michael · Nashville, TNBuilt 1978 · S/N 32R-7887051 N191TASanborn Map Company Inc · Colorado Springs, COBuilt 1974 · S/N 31-7401230

Back to AD 91-21-01 R1