Skip to content

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.

N8087EJd Aviation Inc · Muskegon, MIBuilt 1979 · S/N 32R-8029019 N808ABSunward Aviation Services LLC · Merritt Island, FLS/N 31-8052128 N808DLSons Aviation Inc · Moody, ALBuilt 1967 · S/N 32-40309 N808DTGh Aircraft Leasing LLC · Coconut Creek, FLBuilt 2001 · S/N T20608278 N808WYTriple B Aviation LLC · Kalispell, MTBuilt 2012 · S/N 4636536 N8090TN8090t LLC · Austin, TXBuilt 1979 · S/N 32R-8029020 N8095PGramas Illya W · Shelby, MIBuilt 1962 · S/N 24-3344 N8096JBullgoose Aviation Inc · York, PANon-citizen corporation, flight hours not reportedBuilt 1979 · S/N 32R-8029006 N8097CImmell Michael · Buffalo, OKBuilt 1975 · S/N 32-7640052 N809BWGilly Christian · Newtown, PABuilt 2005 · S/N 27-0334 N809CJl & R Aviation LLC · Hays, KSBuilt 2010 · S/N 4636485 N809DWReed Land & Properties LLC · Kalispell, MTBuilt 2002 · S/N T18208109 N809FTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N T18209209 N80DECampbell Bradford D · Groton, CTBuilt 1973 · S/N 74-31083 N80FFP A M Aviation LLC · Portsmouth, NHBuilt 1972 · S/N 27-7304958 N80GVMoro Aircraft Leasing Inc · Two Rivers, AKBuilt 1975 · S/N 31-7552003 N80LKEti Aviation LLC · Boynton Beach, FLBuilt 1977 · S/N 31-7712103 N80NDMerrifield Robert Craig · Fitzgerald, GAS/N 24-4164 N80RLGree LLC · Hobbs, NMBuilt 2014 · S/N 4636646 N80TPGlobal Aerials Inc · Pembroke Pines, FLBuilt 2012 · S/N GA8-TC 320-12-181 N810KCBlocker Cale · Savannah, GABuilt 1981 · S/N 32R-8129050 N810MJCampbell Fred Cox · Monroe, NCBuilt 1974 · S/N 32-7440082 N8118XSchultz Robert J · Rapid City, SDBuilt 1979 · S/N 32R-8029011 N8118ZWest Metro Aviation LLC · Buffalo, MNBuilt 1979 · S/N 32R-8029013 N811CBRfw Construction Group LLC · Dyersburg, TNBuilt 1974 · S/N 31-7512001 N811CSSheldon Brent Robert · Warwick, NYBuilt 2012 · S/N T18209081 N811PEPalmito Resources Lc · Dallas, TXBuilt 2007 · S/N T18208731 N811PJObrien Neal J · Milton, GABuilt 1969 · S/N 3051 N8124YMatthews Grover C · Hardinsburg, KYBuilt 1966 · S/N 27-3237 N8125DBas Part Sales LLC · Greeley, COBuilt 1979 · S/N 32R-8029014 N8126PCsm Holding LLC · Boscobel, WIBuilt 1963 · S/N 24-3379 N8127ZCrawford Oil Co Inc · Hayti, MOBuilt 1979 · S/N 32R-8029017 N8128BMcguinnis Joseph G · Scottsdale, AZS/N 32R-8029018 N812BEHubbell Aero LLC · Fairfax, VABuilt 1999 · S/N 3257115 N812DKTranscendent Enterprises Inc DBA · Pine Grove, CABuilt 2005 · S/N 3257397 N812HVPinpoint Locating Inc · Altoona, ALFirst renewal noticeS/N T20609098 N812MFj Aviation LLC · Texarkana, TXBuilt 2000 · S/N 32-57162 N812MBOeth Laurence B III · Midland, TXBuilt 1997 · S/N 4636111 N812TBTwin Aviation LLC · Coushatta, LABuilt 1981 · S/N 31-8152113 N8137VAeolus Aviation LLC · River Hills, WIBuilt 1980 · S/N 32R-8029003 N8138PFrank Castillo Dds Inc · San Jose, CABuilt 1963 · S/N 24-3392 N813JHKqm Aviation · Bristow, VABuilt 2010 · S/N T20608964 N81436P&C Construction Inc · Chattanooga, TNBuilt 1979 · S/N 32R-8029045 N8144GDistant Horizons LLC · Park City, UTBuilt 1979 · S/N 32R-8029047 N8148YJustison David L · Hillsboro, ILBuilt 1982 · S/N 32R-8329005 N814CVJam Zoom Yayos LLC · Manheim, PABuilt 2002 · S/N 2137 N814FARivinius Sam · Danville, CABuilt 2003 · S/N T18208214 N814TFRsb 2.0 LLC · Wilton, CTBuilt 2012 · S/N 4636552 N81573Jsham LLC · Sheridan, WYS/N 32-8024004 N8158BRegistration Pending · Springfield, MORegistration pendingS/N 32R-8229038

Back to AD 71-13-01 R1