Registered aircraft · 6,916

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.

N7742VNorbury Ross · Boonville, MOBuilt 1969 · S/N 1495 N774DMSn Holdings LLC · Des Moines, IABuilt 2020 · S/N 4636774 N774FLSacramento County Sheriff'S Office · Sacramento, CABuilt 2023 · S/N T20609736 N774FSHilty Kenneth C · Greensboro, NCBuilt 2000 · S/N 3257192 N775DLN775dl LLC · Orange, CABuilt 2012 · S/N 4636550 N775DSFlight Ventures LLC · Charlotte, NCS/N T18208498 N775RAMojave 775ra LLC · Roseburg, ORBuilt 1982 · S/N 31P8414038 N775TSSmith Paul A · Trufant, MIBuilt 1976 · S/N 27-7654069 N7761VLangley Richard A · Sheyenne, NDBuilt 1969 · S/N 1518 N776AMPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 4636876 N776KRRoman Carlos · Aguadilla, PRBuilt 2008 · S/N 4692071 N776NGMaus Air LLC · Dallas, TXBuilt 2021 · S/N 4636776 N7772HGws Contractors Inc · Bonne Terre, MOBuilt 2004 · S/N T18208257 N7772VHauser Linda L · Ulysses, KSBuilt 1969 · S/N 1515 N7772WWadhwa Anil Jethanand · Clarksville, TNBuilt 2004 · S/N 18281336 N7774VMarshall Soaring Club Inc · Marshall, MIBuilt 1969 · S/N 1528 N7775BCessna 206 LLC · Sun Valley, IDBuilt 2000 · S/N T20608197 N7777FPlastech Corporation · Atlanta, GABuilt 1989 · S/N 4622016 N7777GNittany Flyin LLC · Amarillo, TXBuilt 1991 · S/N 4622118 N7779TDavidson Thad · Whitehouse, TXBuilt 1978 · S/N 32R-7887196 N777ACAerozona 1 Inc · Phoenix, AZBuilt 2016 · S/N 4636687 N777BSMathison John M · Del Norte, COBuilt 1969 · S/N 61-0043-84 N777CMCentral Airlines Inc · Leawood, KSBuilt 1964 · S/N 1412-147 N777DFOl Hughes LLC · Staplehurst, NEBuilt 1972 · S/N 24-5019 N777HZCb Auto Inc · Columbia, MDS/N 31-7405177 N777JLRegistration Pending · Lighthouse Point, FLRegistration pendingBuilt 2021 · S/N 4636792 N777JYKingslyn Ltd · Wilmington, DEBuilt 1978 · S/N 31-7912004 N777MEDe La Garza De La Fuente Jose A · Montgomery, TXBuilt 1980 · S/N 31-8012049 N777PGLee Christopher M · Enid, OKBuilt 2010 · S/N 4636486 N777RZRapid 6 Flyers LLC · Rapid City, SDBuilt 1970 · S/N 32-40907 N777SCInternational Air Services Inc Trustee · Carson City, NVBuilt 1969 · S/N 31-596 N777VZFreeman Brooks · Richmond, VABuilt 1981 · S/N 31-8212012 N777WLucky Shot LLC · Dayton, OHBuilt 1977 · S/N 32R-7780297 N777WZM6 Aviation LLC · Acworth, GABuilt 2011 · S/N 4636491 N777XTBeach Travis W · Bishop, CABuilt 2005 · S/N 1-B N777YUEvenhaim Ronen · Canoga Park, CABuilt 1980 · S/N 32R-8029065 N777ZMFriar Aerospace Group LLC · Dover, DEBuilt 1980 · S/N 31-8052193 N7783VWarhol Peter J · Peever, SDBuilt 1970 · S/N 1536 N778CWingnut Aviation Group LLC · Seymour, CTBuilt 2006 · S/N 3255046 N778DLSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1999 · S/N T20608073 N778EJobin Lyle · Saint Augustine, FLS/N 61P-0434-161 N778MCWilkins Jason Samuel · Powell Butte, ORBuilt 2007 · S/N T18208711 N7799VCb Aerial Application LLC · Kirksville, MOBuilt 1970 · S/N 1552 N779MCDonahue Robert J · Akron, OHBuilt 2007 · S/N T18208770 N779MRRock N Robins Flying Service LLC · Palm City, FLBuilt 1976 · S/N 27-7654047 N77AJGreen Nicholas S · Lakeland, TNBuilt 1976 · S/N 32R-7680371 N77DSBalderas Alberto · Harlingen, TXS/N 317812061 N77DUChaffee Merilyn D · Angwin, CABuilt 1999 · S/N 3257101 N77DXWolfert Jonathan M · Dallas, TXBuilt 1998 · S/N 27-0253 N77EWBellanca Aviation Of Blairstown LLC · Andover, NJBuilt 1974 · S/N 74-32-137

Back to AD 71-13-01 R1