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.

N6934JCopaair Maintenance Services Inc · Indiantown, FLBuilt 1976 · S/N 32R-7680389 N693MEDicky David J · Sierra Vista, AZS/N 3228 N693TCBrooks Janousek LLC · Kingsford, MIBuilt 1997 · S/N 20018 N6940FRebel Ranch LLC · Glenwood, ARBuilt 1976 · S/N 32R-7780050 N6943YAce Tomato Co LLC · Daytona Beach, FLBuilt 1969 · S/N 27-4350 N6944APacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 27-7954109 N6944YLg Aztec LLC · Boynton Beach, FLBuilt 1969 · S/N 27-4304 N694BKBell Bruce · Desert Aire, WABuilt 1969 · S/N 1851582 N694BWOtter Creek Aviation LLC · Columbus, GABuilt 2004 · S/N T18208262 N694DBHammond Flying Club Inc · Covington, LABuilt 1975 · S/N 32-7540087 N694PCBajedi Aviation LLC · Lewes, DEBuilt 2002 · S/N 3257305 N694RJAtlas 182rj LLC · Port Townsend, WABuilt 2005 · S/N T18208473 N694STMcmillion Air LLC · Franklin, INBuilt 2016 · S/N 4636694 N6952YPorterfield Brian B · Wasilla, AKBuilt 1969 · S/N 27-4316 N6953JDubois Marcus S · Olive Branch, MSBuilt 1976 · S/N 32R-7680393 N6954JHughston Thomas Price · NorfolkBuilt 1976 · S/N 32R-7680394 N6955YN6955y LLC · Knoxville, IABuilt 1969 · S/N 27-4320 N6956YTolsma Michael J · Hawthorne, NJBuilt 1969 · S/N 27-4321 N6961JBaja Airventures Inc · Chula Vista, CABuilt 1976 · S/N 32R-7680395 N6962SYeaman John Robert IV · Aroda, VABuilt 2000 · S/N 4636272 N696JANational Industrial Services LLC · Kingshill, VIBuilt 1965 · S/N 27-2924 N6970YBell Daniel E · Alexandria, KYBuilt 1969 · S/N 27-4337 N6971YNovember Nine One Four Eight Juliet LLC · Fulton, MOBuilt 1969 · S/N 27-4338 N697EFElam Nathan A · Hereford, TXBuilt 2012 · S/N T20609043 N697MMHarmon Aviation LLC · Oxford, MIBuilt 2008 · S/N 4692097 N697WHAgri Enterprises LLC · Hopkinsville, KYBuilt 1983 · S/N 31-8352008 N698HNelson Bobby E · Naples, FLBuilt 1968 · S/N 27-4106 N698VWSheppard Louis A · Queens Village, NYBuilt 1974 · S/N 31-7405408 N699AWTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N T20609855 N699MDJvation LLC · Belgrade, MTBuilt 1994 · S/N 4622159 N699PGBrady Richard V · Show Low, AZBuilt 2013 · S/N 4636600 N699TBUS Anesthesia Consultants LLC · Chesterfield, MOBuilt 1994 · S/N 4622158 N69CPBuena Vista Hunting LLC · Eagle Pass, TXBuilt 2005 · S/N T20608564 N69FMAirtime LLC · South Lyon, MIBuilt 1976 · S/N 32R-7680200 N69JWWarrior Aviation LLC · Dollar Bay, MIBuilt 1972 · S/N 31036 N69JYInternational Air Services Inc Trustee · Carson City, NVBuilt 2006 · S/N T20608627 N69LHGraham Jack · Hamilton, TXBuilt 1977 · S/N 32R-7780323 N69LVTbd Air LLC · Chatham, MABuilt 2001 · S/N 3257229 N69MKFisher Jack C · Ashland City, TNBuilt 1998 · S/N 3257063 N69PTAerofix Structural Service LLC · Horn Lake, MSS/N 1397-143 N69WPHutcheson Jon · Greencastle, INBuilt 1973 · S/N 32-7440015 N6ARBluewater Airmotive Corporation · Wilmington, DEBuilt 1973 · S/N 31-7300914 N6HTColorado By Air LLC · Salida, COBuilt 2003 · S/N T20608387 N6TSRd Leasing LLC · Salem, ORS/N T20609557 N6UCZborowski Ronald W · Eighty-Four, PABuilt 1975 · S/N 27-7554079 N7008FSouthbound Aviation LLC · Jackson, TNBuilt 1976 · S/N 32-7740012 N700ABSale Reported · Lewes, DESale reported, pending cancellationBuilt 1977 · S/N 61P-0401-139 N700AKCampbell Mark D · Ashford, ALBuilt 1979 · S/N 70017 N700CMoss Donald · Pinecrest, FLBuilt 1974 · S/N 31-7405497 N700GCRicks Auto Clinic Inc · Raytown, MOBuilt 1977 · S/N 32-7740054

Back to AD 71-13-01 R1