Registered aircraft · 6,915

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:71-13-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:71-13-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:71-13-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:71-13-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:71-13-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:71-13-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.

N185KPNg Research · Bristow, VABuilt 2015 · S/N T20609185 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 N18691869 Leasing LLC · Aurora, ORBuilt 2008 · S/N T20608802 N186STInternational Air Services Inc Trustee · Carson City, NVBuilt 2008 · S/N 4692086 N1872EAmerican Valet Air Inc · Wilmington, DEBuilt 1980 · S/N 31-8052114 N1872HDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 31-7652053 N187DHPsl Surveys · Bristow, VABuilt 2015 · S/N T20609187 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 N188CSJaae Inc · North Miami Beach, FLBuilt 2014 · S/N T20609118 N188KCMalibu Management LLC · Ponte Vedra, FLBuilt 2013 · S/N 4636588 N188LAAvf Flyers LLC · Richmond, VAS/N 4636185 N188LGMyskinmedspa LLC · Rockledge, FLBuilt 1989 · S/N 4622043 N188SEChernov Boris · Lima, OHBuilt 1978 · S/N 32R-7885255 N188SPThornado Aviation LLC · Indialantic, FLBuilt 1977 · S/N 32R-7780309 N188SSNby Productions · Bristow, VABuilt 2015 · S/N T20609188 N189CBOtv Leasing · Bristow, VABuilt 2015 · S/N T20609189 N189GTKenai Aviation LLC · Akron, OHBuilt 2001 · S/N 2022 N189JCTulare County Sheriff · Visalia, CABuilt 2017 · S/N T20609510 N189JMJsc Rentals LLC · Missoula, MTS/N T20608782 N189JPMontana Skies LLC · Kalispell, MTBuilt 2011 · S/N T18209053 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 N18GXStamp Investments LLC · Oregon City, ORS/N 27-0318 N18HLBusinessliner Inc · Ft Lauderdale, FLBuilt 1980 · S/N 31-8052055 N18JMDixon John F · Hayden, IDBuilt 1999 · S/N 4636229 N18JSAdelaar Holdings LLC · Missoula, MTBuilt 2016 · S/N 4636702 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 N190KCHi Fly Aviation LLC · Harrisonburg, VABuilt 2008 · S/N 4692090 N190PDCommonwealth Of Puerto Rico Policia Of Puerto Rico · San Juan, PRBuilt 2015 · S/N T20609161 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 N191MBFvx Research · Bristow, VABuilt 2015 · S/N T20609191 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 71-13-01 R1